Printing Problems

How to Fix Access Report Printing Multiple Copies of the Same Page

Partner Editor Oct 10, 2026 871 views

Question details

The user needs to stop a Microsoft Access report from printing or exporting multiple identical copies of the same page.

How to Fix Access Report Printing Multiple Copies of the Same Page

Product: Microsoft Access
Device & OS: not provided
Scenario: Exporting or printing a report that calculates order totals and sales tax using a calculated query field.
Observed behavior: The report outputs multiple duplicate pages (e.g., five copies of the same page) corresponding to the number of line items in the order details.

Before you start

Before modifying your database queries or report layouts, ensure you create a backup copy of your Microsoft Access file to prevent accidental data loss or breaking existing report functionality.

Solution 1Recommended

Calculate Totals Using a Separate Aggregate Query

Resolve the duplication issue by removing the calculated field from the report's main record source and calculating totals in a separate query.

When a report's record source includes a query with line-item calculations (like order details), Access multiplies the output pages by the number of line items. Separating the totals calculation into an aggregate query prevents the report from repeating pages.

Modify the main report query

Open your database in Microsoft Access, navigate to the query currently used as the report's record source in Design View, and remove the calculated field (such as `ItemTotal`) that is causing the duplication.

Create a totals query

Create a new query and use the Group By function to group the data by your primary identifier, such as Quote or Order ID.

Add calculated fields

In the new totals query, add a calculated column for the sum using an expression like `Sum([PPrice]*[PQty])`, and add another column for the sales tax calculation.

Update the report design

Open your report in Design View. Bind these newly created aggregate fields to text boxes placed in the Report Footer or Group Footer section.

Calculate Totals Using a Separate Aggregate Query

Verification: By separating the line-item calculations from the aggregate totals, the report will now correctly display one page without duplicating records based on order details.

Solution 2

Check Grouping and Force New Page Settings

Ensure that the report's sorting, grouping, and pagination properties are not forcing unnecessary page breaks.

Free Microsoft Office alternative

Try WPS Office for Your Document and Data Needs

While Microsoft Access handles complex relational databases, WPS Office offers a free, lightweight, and highly compatible alternative for managing your daily documents, spreadsheets, and presentations. With WPS Spreadsheet, you can perform powerful data calculations, build charts, and manage lists without the complexity of a full database system.

1. Download and install: Visit the WPS Office website to download the free suite for your Windows, Mac, or Linux operating system.
2. Open your data files: Launch WPS Spreadsheet and open your existing .xlsx or .csv data files directly without any formatting loss.
3. Analyze and print: Use built-in pivot tables and formulas to calculate totals and print your data reports seamlessly.

Free, lightweight, and fast-performing Office suiteExcellent format compatibility with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx)Familiar user interface for a seamless transitionBuilt-in PDF editing and powerful spreadsheet calculation tools

Frequently Asked Questions

Why does my Access report repeat the same record multiple times?

This typically occurs when the report's record source is based on a query that joins a 'one' table to a 'many' table (such as Orders to Order Details) without proper grouping. As a result, the main record repeats for every related detail row.

How do I calculate a grand total in an Access report?

To calculate a grand total, open the report in Design View, add a Text Box to the Report Footer section (not the Page Footer), and set its Control Source to an expression like `=Sum([FieldName])`.

What does the 'Force New Page' property do in Access?

The 'Force New Page' property determines whether Access should start a new printed page before or after rendering a specific report section, such as a Group Header, Group Footer, or Detail section. Setting this incorrectly is a common cause of unexpected blank or duplicate pages.

Document & File Issues