Access 2016 Intermediate

Lesson 12 - Using Advanced Report Design

Access 2010

C REATING A R UNNING S UMMARY



Discussion

In a grouped report, you can create a running summary of the items in the group. A running summary provides a cumulative total for all the groups above.

Often, the running summary is positioned in the group footer, which appears at the bottom of every group. For example, in a sales report grouped by region, you can create a calculated field that displays information in a running summary. After each group, a cumulative total for all groups appears above.

Using an expression to create a running summary



Procedures

1. Open the desired report in Design view. 2. Create the group summary calculated control expression. 3. Select the calculated control. 4. Press [F4] to display the Property Sheet . 5. Select the Data tab. 6. Select the Running Sum property.

7. Select the Running Sum list. 8. Select the desired option.

Page 226

OFFICEPRO, Inc.