How to get a running total for DR and CR


Syphon Hinds

Hey guys,

I'm kinda new to microsoft access database and i'm having a problem with getting a running balance calculated from Dr and CR transactions..How to I create the running total?

Access Developer


I'm guessing you are talking about transactions of type debit and credit,
identified by something other than a plus or minus amount, showing the
amount on both as a positive value.

If so, then you create a query with the fields you want to show, and a
calculated field (setting the amount to positive or negative depending on
the type of transaction). On the Text Box in which you show this field,
select Running Sum in the Data Tab of the Property Sheet, and set it to Over
All or Over Group, as you desire.

If not, be more precise in describing what you have and what you want, and
perhaps someone here can help.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question