Fix a Microsoft Access Report That Prints Repeatedly or Will Not Preview
Question details
Identify why an Access report repeats for each subreport record and check whether the same query issue affects Print Preview.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A main report displays related records in a subreport and needs to print once per primary record.
- Observed behavior
- The main report repeats once for each subreport record and may not preview as expected.
Identify the primary key for the main report records and the field that links them to the subreport records. Open the database in Access and locate both reports in the Navigation Pane.
Remove duplicate parent rows from the main report record source
Use this approach when the main report prints once for every related subreport record.
In the Navigation Pane, right-click the main report and select Design View. Open the Property Sheet, select the report, and check Record Source on the Data tab.
Open the query named in Record Source, or use the build button beside the property to inspect it. Run the query and check whether the primary key appears more than once.
In Query Design, remove joins to related detail tables that multiply parent rows when those tables are only needed by the subreport. Keep the main query at one row per primary record; use grouping or aggregation if related values are needed in the main report.
Open the subreport in Design View and check its Record Source on the Property Sheet's Data tab. Use a separate query that returns the related detail records.
In the main report's Design View, select the subreport control and check Link Master Fields and Link Child Fields on the Property Sheet's Data tab. Set them to the matching parent and child fields, save the reports, and open the main report in Print Preview.

Use WPS Office for Documents and Spreadsheets Alongside Access
WPS Office is a free, lightweight, easy-to-use alternative for everyday document and spreadsheet work. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files. It does not repair or replace an Access database report.

Frequently Asked Questions
Why does my Access report print six times when the subreport has six records?
The main report query may return the parent record once for each related detail record. Open the main report in Design View, check Record Source on the Property Sheet's Data tab, and run the query to look for repeated primary keys.
How should I connect the main report to its subreport?
In the main report's Design View, select the subreport control. On the Property Sheet's Data tab, set Link Master Fields to the parent field and Link Child Fields to the matching field in the subreport source.
Should the main report query include the subreport's detail table?
Not if the join creates multiple rows for each parent and the detail records are only needed in the subreport. Use a separate subreport query for those records, or aggregate the detail data if the main report needs a summary.
Will fixing duplicate rows always restore Print Preview?
No. Correcting the record source can fix repeated output and may resolve related preview behavior, but preview failures can have other causes. Check the error message and investigate the report, query, and printer settings if the problem remains.




