How do I calculate the running balance in a ledger in Access?

H

Heather

I am trying to do a transaction listing report in Access. I would like a
running balance at the end of each transaction listing instead of just a
balance of the specific listing on that line. Example:
(balance 500.00)
deposit
100.00 100.00(instead I would like this to be 600.00)
withdrawal 50.00 -50.00 (should be 550.00) etc.
Any help would be appreciated!
 
M

Marshall Barton

Heather said:
I am trying to do a transaction listing report in Access. I would like a
running balance at the end of each transaction listing instead of just a
balance of the specific listing on that line. Example:
(balance 500.00)
deposit
100.00 100.00(instead I would like this to be 600.00)
withdrawal 50.00 -50.00 (should be 550.00) etc.
Click to expand...


Use a test box with it's RunningSum property set to Over
All.

I'd be more specific, but you didn't provide sufficiently
detailed information for me to explain how to apply this in
your report.
 
B

bobgalway

This is routine in a Report..although you can do alot of stuff like thi
in a query: For example: Field1 (from Table) * Field 2 (from Table)
Field3 (exists in Query only)
 
Top