# How to Sort Records in Reports MS Access

> To sort records in reports MS Access, locate the report in the Navigation Pane, open Design View, and click the Group & Sort button on the Design tab. Add a sort, select the field and sort order, then switch to Report View to check the results.

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

## Steps

1. In the 'Navigation Pane', locate the report you want to sort.
2. Right-click the report and select 'Design View'.
3. On the 'Design' tab in the Ribbon, locate the 'Group & Sort' button.
4. Click 'Add a Sort'.
5. Select the field you want to sort by from the dropdown list.
6. Choose the sort order.
7. Switch to 'Report View' to check the sorting order.