O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required