# How to Add Grouping Levels Reports MS Access

> To add grouping levels in MS Access, open your database and open your report in Design View. Go to the Report Design tab, click Group & Sort, and open the pane at the bottom. Click Add a group, choose a field, click OK, and save your changes.

Canonical: https://livedemo.ai/tutorials/how-to-add-grouping-levels-reports-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2df3d673bd5aa8e5fc19/preview?step=1

## Steps

1. Open your database.
2. Navigate to the 'Reports' section.
3. Right-click on the report you want to modify and choose 'Design View' from the context menu.
4. In the 'Report Design' tab in the Ribbon, click 'Group & Sort' in the 'Grouping & Totals' group.
5. A pane will appear at the bottom of the window where you can define grouping levels and sorting rules. Click 'Add a group' in the 'Group, Sort, and Total' pane.
6. Choose a field from the list and click 'OK'.
7. Click the save icon to save the changes.