Running Balance Query

[FARAZ QURESHI]

I have a table with 2 major fields showing Debit (+) & Credit (-)
Transactions of a party. I want to desgin a query so that a third column
appears shows running balance as follows:

DEBIT CREDIT BALANCE (REQUIRED)
10,000 0 10,000
5,000 0 15,000
7,000 2,000 20,000

 

[Arvin Meyer [MVP]]

You can do this in a report, but not on a form. In the report, use a textbox
and set the Running Sum property to Over All.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "RunningSumInQuery.mdb" which illustrates how to do this. It
doesn't exactly match your situation because it does a running sum of a
single column, but you should be able to modify it to your circumstances.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L