Hints and tips home » Access hints and tips » Run with the total

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options
Ø No

§ This Item is not a running total

Ø Over Group

§ This Item is a running total which will reset to zero with each new group value

Ø Over All

§ This Item is a running total which will total over the whole report

Added by Alan on 16th September 2006

More Access hints and tips, like:

• Modal forms
• Relationship maps
• How To Find All Overdue Accounts?