Access 2016 Intermediate

Access 2010

Lesson 12 – Using Advanced Report Design



Step-by-Step

Create a running summary in a report.

If necessary, display the ruler.

Open the Items by Order 4 report in Design view and maximize the window.

Scroll as necessary to display the Order Number Footer section and select the calculated control to the right of the Total for Order label.

Steps

Practice Data

1. Press [F4] to open the Property Sheet . The property sheet for the selected text box opens.

Press [F4]

2. Select the Data tab.

Click the Data tab

The Data page appears with the insertion point in the Control Source property box. 3. Select the Running Sum property. The insertion point appears in the Running Sum property and an arrow appears to the right of the property.

Click the Running Sum property

4. Select the Running Sum list. A list of options appears.

Click Running Sum

5. Select the desired option.

Click Over Group

The desired option appears in the Running Sum property.

Preview the report. Scroll as necessary and notice the cumulative subtotals calculated for each order number. Switch back to Design view.

OFFICEPRO, Inc.

Page 227