How to Create Subreport in MS Access: 1-Min Guide

How to Create Subreport in MS Access

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to embed a subreport inside an existing MS Access report.

Quick summary

A subreport in MS Access lets you display related data from a secondary report inside a main report, enabling richer, multi-dataset outputs. You can create a subreport in just a few steps using the built-in Subform/Subreport Wizard in Report Design View.

Steps

Right-click the main report and select Design View to enter edit mode.
From the Report Design tab, drag the Subform/Subreport control onto the main report canvas.
Position the control in the appropriate section of the report layout.
When the Subreport Wizard opens, select Use an existing report, choose your subreport, and click Next.
Name your subreport and click Finish to complete the wizard.
Open the main report in Report View or Print View to verify the subreport displays correctly.

📌 Why this matters

Creating a subreport in Microsoft Access allows users to combine related data from multiple tables or queries into a single, unified report output. This is essential for database reporting workflows where parent-child data relationships — such as orders and order details — need to be presented together. The built-in Subreport Wizard makes it straightforward to embed an existing report as a subreport without writing any code. Mastering this feature helps Access users build more powerful, professional reports that surface deeper insights from their relational data.

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