Re: Make the ending balance the next days beginning balance in MS Acce



Jim

Where are you getting the numbers from (i.e., what data/table structure are
you using)?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Jim McC" <Jim McC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A443A29B-2C29-462B-879B-8078CE1AEDAE@xxxxxxxxxxxxxxxx
On a form and report I am trying to make the one days ending balance
appear
as the following days beginning balance (e.g)

Day Beginning Balance Income Expenses Ending Balance
Mon 10 15 5
20
Tue 20 10 15
15
Wed 15 5 15
5
....

I am using a crosstab query to calculate my income and expense column
numbers and I can do the math on the form to get the ending balance, but I
am
not able to make my ending balance the next days beginning balance.

Thanks for your advice


.



Relevant Pages

  • Report Limitation
    ... view of the query for the ending balance information. ... FROM tblMONTHYEAR INNER JOIN (tblBANK INNER JOIN tbl_ARVEST ON tblBANK.BANKS ... I am having difficulty in obtaining the correct ending balance. ...
    (microsoft.public.access.reports)
  • Re: For Marshall Barton
    ... I want a total of the beginning balance ... the ending balance. ... a Main Report: rpt_AFinancialStmt. ... I think you need to add a text box (named txtRunInc) to the ...
    (microsoft.public.access.reports)
  • RE: setting a value in one record equal to the value in another re
    ... Actually, Clifford, a record for each month is already created. ... January's ending balance it will update the beginning balance in the February ... I only have one record per month; never two records for the same EmployeeID ...
    (microsoft.public.access.forms)
  • Re: Interest calculation
    ... through the month and posted as a single amount the following month. ... Where the balance or rate changes from day to day, ... I'm sure that varies from bank to bank. ... where A1:C1 is an entry for the ending balance of the previous month, ...
    (microsoft.public.excel.worksheet.functions)
  • RE: setting a value in one record equal to the value in another record
    ... EndingBalance (a calculated field) ... I only have one record per month; never two records for the same EmployeeID ... I want the opening balance for one month to equal the ending balance in the ...
    (microsoft.public.access.forms)