# How to Create Nested Reports MS Access

> To create nested reports in MS Access, open the main report in Design View and add the SubReport object. Use the Subreport Wizard to link the reports, select linking fields, and name the subreport. Finally, switch to Report View to verify that related data displays properly for each record.

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

## Steps

1. Open the main report in 'Design View'.
2. Drag and drop the 'SubReport' object from the Navigation Pane to the desired location in the main report.
3. Use the 'Subform/Subreport Wizard' to link the subreport to the main report. Click 'Next'.
4. Select the fields to link the main report and subreport. Click 'Next'.
5. Name your subreport and click 'Finish'.
6. Switch to 'Report View' .
7. Verify that the subreport displays the related data properly for each record in the main report.