M
MikeG2010
Hi. I am trying to create a formula which will up date an opening and
closing balances in a query named Bank query.
The fields in the query are: ID, BDate, OpBal, Debit, Credit, ClBal. The
formula I am trying to create takes the previous days ClBal as the new OpBal.
The next step is to add the Debit field value and subtract the Credit field
value; to come up with a ClBal. The whole process repeats on the next day.
Any help would be greatly appreciated.
closing balances in a query named Bank query.
The fields in the query are: ID, BDate, OpBal, Debit, Credit, ClBal. The
formula I am trying to create takes the previous days ClBal as the new OpBal.
The next step is to add the Debit field value and subtract the Credit field
value; to come up with a ClBal. The whole process repeats on the next day.
Any help would be greatly appreciated.