quary addition subtraction

[agyapong isaac]

On my form, I have:
Name, Date of transaction, Debt, Credit, balance
If John pays $100 on the date 21/01/2012 and withdraws $60 on the 25/01/2012 and pay $25.50 and $80 on the 01/02/2012 and 13/02/2012 and on the 13/02/2012 withdrawn $10.
I would like query table or a report to display something like this

Name	Date of transaction	Debt	Credit	Balance
John	21/01/2012		$100.00	$100.00
John	25/01/2012	$60		$40.00
John	01/02/2012		$25.50	$65.50
John	13/02/2012		$80.00	$145.50
John	13/02/2012	$10		$135.50

[June7]

A running balance like that is not easy to do in query or on form. Textbox on report has a RunningSum property that does make this easy on a report. Create a textbox on report with expression in ControlSource: =Nz([Credit])-Nz([Debit]). Set the RunningSum property to OverAll.

[ssanfu]

You might look at "Rogers Access Library". There is an example of a running sum in a query.

RunningSumInQuery.mdb (beginner)
http://www.rogersaccesslibrary.com/forum/topic279.html