How to Create Nested Reports MS Access: 1-Min Guide

How to Create Nested Reports MS Access

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to build nested reports with subreports in MS Access.

Quick summary

Creating nested reports in MS Access lets you embed a subreport inside a main report to display related data side by side for each record. Use the built-in Subform/Subreport Wizard to link the two reports through shared fields without writing any code.

Steps

Open the main report in Design View.
Drag and drop the SubReport object from the Navigation Pane to the desired location in the main report.
Use the Subform/Subreport Wizard to link the subreport to the main report, then click Next.
Select the fields to link the main report and subreport, then click Next.
Name your subreport and click Finish to complete the wizard.
Switch to Report View to preview the combined report layout.
Verify that the subreport displays the correct related data for each record in the main report.

📌 Why this matters

Nested reports in Microsoft Access allow database users to present hierarchical or related data in a single, consolidated view — eliminating the need to cross-reference multiple separate reports. By embedding a subreport inside a main report using the Subform/Subreport Wizard, teams can surface linked records such as orders within customers or tasks within projects with no custom code required. This capability is essential for users who need to produce structured, multi-level reports directly from their Access database for analysis, audits, or client-facing documentation.

Your product deserves an interactive demo

Start free

How to Integrate a Microsoft Excel Database with Excel

How to Integrate Google Calendar with an MS Access Database

How to Integrate Google Sheets with an MS Access Database