query for a bank statement

  • Thread starter Thread starter aa
  • Start date Start date
A

aa

I have a table which shows activity on a bank accouint for a certain
period. There is a field "amount" where withdrawals are shown as negative
and money credited are positive. I need to present it as a bank statement
adding a field with the balance after each transaction.

I am trying to figure out a query which would add a new field where the
balance afrew which transaction is shown, i.e. the value of "amount" from
the current line plus the value of the balance from the previous line.
Will someone provide a hint?
 
Could you do this as a report?

On a report, you could add the Amount field twice.
In the 2nd copy, set the Running Sum property to: Over Group
It will sum all the withdrawals and credits, and act as a balance.
 
Back
Top