Rolling over ending balance to beginning balances

[Guest]

I am building a database for use in an accounting department. Specifically,
we will be rolling forward various banking activities on a daily basis. The
formula is pretty basic:
Beginning balance + inflows - outflows = ending balance

There is a record created for each day. Although I can calculate the ending
balance, I'd really like to populate the ending balance in the beginning
balance field of the following day. Is there a way to do this? Thanks.

Dennis

 

[JohnFol]

There are dozens of ways, for example if the closure of the days accounts is
a button click, you could run an AppendQuery, using the newly calculated
ending balance as a parameter . Alternatively you could open the recordset
and .AddNew.

Or, if the update is done via a form, why not have a piece of code on the
OnCurrent that does

If isnull(Me!Opening Balance) Then Me!Opening Balance = DLookup ("closing
balance", "banking activities", "BankingDay = " & Me!BankingDay -1)