Example of a report that calculates running sums

You can calculate running sums that accumulate within each group and are reset each time a new group of records begins. You can also calculate running sums that accumulate throughout the report.

In the following illustration, for the two fields on the right that are bound to the Subtotal field, the RunningSum property is set to Over Group and Over All, respectively.

Text boxes that calculate running sums shown in Design view

In the following printed report, you can see how Microsoft Access calculates the running sums.

Running sums shown in printed report