Microsoft® Office Access™ 2007 Plain & Simple

Grouping Report Records

When you create a report using the Report Wizard, you can define how the report’s records are grouped. For example, you can create a report based on the Northwind sample database’s Orders and Order Details tables and group records by Customer ID. If you want to display each customer’s orders by the date they were placed, you can create a second grouping level based on the Order Date field.

When you add a grouping level to a report, Access adds a header corresponding to the grouping field’s name. If you group a set of products by their category name, Access creates a CategoryName Header; if you like, you can add a CategoryName Footer as well.

Create a Grouping Level

1. Open a report in Layout view.

2. Click the Formatting tab.