query for a bank statement

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"aa" wrote in message
...
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?