Page 6 of 12PREVNEXT

Create reports for a new Access 2007 database

Steps for adding sums in Access 2007


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, 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