How to Add Grouping Levels Reports MS Access

Quick summary

This tutorial shows you how to add grouping levels to a report in Microsoft Access using the Group, Sort, and Total pane in Design View. By defining grouping levels, you can organize report data into structured, easy-to-read categories directly within Access.

Steps

1. Open your database in Microsoft Access.
2. Navigate to the Reports section in the database navigation pane.
3. Right-click on the report you want to modify and choose Design View from the context menu.
4. In the Report Design tab on the Ribbon, click Group & Sort in the Grouping & Totals group.
5. In the Group, Sort, and Total pane that appears at the bottom of the window, click Add a group to define a new grouping level.
6. Choose a field from the list to group by and click OK.
7. Click the save icon to save your changes to the report.