Others

How to Add Two Unrelated Subreports to a Microsoft Access Main Report

Steve KSteve K Oct 29, 2026 869 views

Question details

The user needs to add two independent, unrelated subreports to a single main report in Microsoft Access.

How to Add Two Unrelated Subreports to a Microsoft Access Main Report
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Main Report in Design View

In the Navigation Pane on the left, right-click your main report and select 'Design View' from the context menu.

2
Select the Subreport Control

Navigate to the 'Report Design' tab on the top ribbon. In the Controls group, click the 'Subform/Subreport' icon.

3
Place the Subreport

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.

4
Configure the First Subreport

When the Subreport Wizard opens, select 'Use an existing report or form', choose your first unrelated report from the list, and click 'Finish'.

5
Add the Second Subreport

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.

Insert Unrelated Subreports Using Subreport Controls
Check Link Properties: Since these reports are unrelated, select the edges of your inserted subreport controls, open the Property Sheet (F4), go to the Data tab, and ensure that both the 'Link Master Fields' and 'Link Child Fields' properties are completely blank.
Free Microsoft Office alternative

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. 1. Visit the WPS Office Website: Go to the official WPS website to access the free download.
  2. 2. Download the Installer: Click the 'Free Download' button to get the setup file tailored for your operating system.
  3. 3. Install and Start Working: Run the installer, follow the on-screen prompts, and immediately begin managing your documents, spreadsheets, and presentations.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight installation that runs smoothly on almost any device.Familiar user interface makes transitioning from Microsoft Office seamless.Provides rich reporting tools in Spreadsheets for data summarization without complex databases.
microsoft office alternative - wps office

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.