Running Total/Balance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Day,

I have a query that contains a column CR_DRAmount -- this contains positive
& negative entries from my table.

How do I create a running total/balance for this field/column.

The column uses an expression:

CR_DRAmount: IIf([Wire]=True,[CR_DRAmt]*-1,[CR_DRAmt])


Thanks,

Brook
 
Brook

You'd probably need to build that running total/balance into a report. The
query (you posted in a query newsgroup) would return all the rows, and your
report could keep a running total.
 
Back
Top