Page 6 of 12PREVNEXT

Create reports for a new database

Adding sums to a report

In addition to grouping and sorting, you can add subtotals, grand totals, and other calculations to your reports. For example, you can calculate how much you spent on a given model of desk or office chair.

Callout 1 With your report still open in Layout view, start the Group, Sort, and Total pane, click a grouping level, and then click More.
Callout 2 Locate the “totaled” field and click the arrow next to it.
Callout 3 Use the Totals dialog box to select the field you want to calculate, the type of calculation you want to use, such as a sum or average, and to set options such as subtotals and grand totals.
Callout 4 When you finish, your report displays the calculations.
Page 6 of 12PREVNEXT