Example of a report that calculates running sums

Microsoft Office Access 2003

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 in Design view

Callout 1 The RunningSum property of this text box is set to Over All.

Callout 2 The RunningSum property of this text box is set to Over Group.

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

Running sums shown in printed report

Callout 1 The value in the Over Group column resets to zero each time a new group begins.

Callout 2 The value in the Over All column accumulates to the end of the report.