How to Add Two Unrelated Subreports to a Microsoft Access Main Report
Question details
The user needs to add two independent, unrelated subreports to a single main report in Microsoft Access.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Designing a complex report in Microsoft Access that requires displaying multiple distinct data sets.
- Observed behavior
- The goal is to display two subreports within a main report where the subreports do not share fields, relationships, or record sources.
Ensure you have already created the individual reports that you intend to use as your main report and subreports, and verify that their record sources are working correctly.
Insert Unrelated Subreports Using Subreport Controls
Add separate subreport controls to your main report header or footer to display independent reports without linking fields.
In Microsoft Access, a single main report can host multiple subreports even if their data isn't related. By placing subreports in the Report Header or Report Footer, you ensure they only print once at the beginning or end of the document, rather than repeating with every record.
In the Navigation Pane on the left, right-click your main report and select 'Design View' from the context menu.
Navigate to the 'Report Design' tab on the top ribbon. In the Controls group, click the 'Subform/Subreport' icon.
Click inside the 'Report Header' or 'Report Footer' section where you want the first subreport to appear. Do not place it in the 'Detail' section unless you want the subreport to repeat for every record.
When the Subreport Wizard opens, select 'Use an existing report or form', choose your first unrelated report from the list, and click 'Finish'.
Repeat the process by selecting the 'Subform/Subreport' control again, clicking a new location in the header or footer, and selecting your second unrelated report through the wizard.

Looking for a lighter, cost-effective alternative to Microsoft Office?
While Microsoft Access is a specialized database tool, most daily tasks only require robust word processing, spreadsheets, and presentation software. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for your core productivity needs.
- 1. Visit the WPS Office Website: Go to the official WPS website to access the free download.
- 2. Download the Installer: Click the 'Free Download' button to get the setup file tailored for your operating system.
- 3. Install and Start Working: Run the installer, follow the on-screen prompts, and immediately begin managing your documents, spreadsheets, and presentations.

Frequently Asked Questions
Why is my subreport repeating multiple times in the main report?
This happens when the subreport is placed in the 'Detail' section of the main report. The Detail section repeats for every individual record in the main report's record source. To fix this, move the subreport into the Report Header or Report Footer.
Do I need to link Master and Child fields for unrelated subreports?
No. If the subreports are completely unrelated to the main report and to each other, you should leave the 'Link Master Fields' and 'Link Child Fields' properties blank in the subreport control's Property Sheet.
Can I use queries as record sources for these unrelated subreports?
Yes, you can use queries, single tables, or direct SQL statements as the bound record sources for your individual reports before you insert them into the main report.




