how do i get the closing balance of previous record as opening bal

[ideaplease]

I am in need of preparing a report in the following columns are required.
Date, Opening Balance, Cash Received, Deposited into bank, Closing Balance
and today’s closing balance should be the opening balance for the next day.
There are three tables viz., Opening Balance (One record only), Cash receipts
and Deposits made into bank.. Is there any way to get today’s closing
balance as opening balance for the next date in a report for a period
example: one month

 

[Allen Browne]

In the context of a report, you could just set the RunningSum property of a
text box so it accumulates the values.

If you want to do it at the query level, see:
Referring to a Field in the Previous or Next Record
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;101081