# How to Create Linked Reports MS Access

> To create linked reports in MS Access, copy and paste the report from the Navigation Pane, rename it, and open it in Design View. Enter a filter condition in the Property Sheet, add grouping and sorting via the Report Design tab, and then save and close the report.

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

## Steps

1. Right-click on the report in the 'Navigation Pane' and select 'Copy' then 'Paste'.
2. Give the copied report a new name and click 'OK'.
3. Right-click on the duplicated report and choose 'Design View'.
4. In the 'Design View', go to the 'Property Sheet' for the report.
5. Locate the 'Filter' property and enter a filter condition.
6. On the 'Report Design' tab, click 'Group & Sort'.
7. Add grouping levels or sorting orders as needed and click 'OK'.
8. Click 'Save' and close the linked report.