Prev: Getting total sales by customer
Next: Access search text string for char, then extract all to right?
From: MikeG2010 on 12 Mar 2010 10:52
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.

 | 
Pages: 1
Prev: Getting total sales by customer
Next: Access search text string for char, then extract all to right?