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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Heather - 07 Jan 2006 20:00 GMT

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!

Reply to this Message

Marshall Barton - 07 Jan 2006 20:39 GMT

>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
[quoted text clipped - 3 lines]
>100.00 100.00(instead I would like this to be 600.00)
>withdrawal 50.00 -50.00 (should be 550.00) etc.

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.

Signature

Marsh
MVP [MS Access]

Reply to this Message

bobgalway - 07 Jan 2006 20:58 GMT

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)

--
bobgalwayPosted from - http://www.officehelp.i

Reply to this Message