How to compute a running total in Access?

[gdougher]

Hello. I administer a Client Access database that includes personal data, support data and billing data for 45 clients. I am trying to track the number of Program Units where I have been given the Total Number Authorized Units (issued in July) and the number of Units Used for each month: July, August, September, October. I would like to be able to see a running Number Current Units Available as we progress through each month. (e.g. [5000 Total Authorized Units] - [150 Units Used for July] = 4850; [4850 Total Authorized Units] - [180 Units Used for August] = 4670; etc.)



I do not use VBA and would therefore like to know if I can do this through a query or series of queries in my Access database. I am familiar with reading code, but you would need to tell me where and how to paste any code you might suggest.

Thanks so much for your assistance.

[June7]

Probably easiest is to build a report and use textbox RunningSum property. Would need to know more about your data structure to advise more.