Others

How to Filter Multiple Access Report Rows by Criteria

Steve K Oct 22, 2026 868 views

Question details

The user needs to display multiple records per page in a Microsoft Access report while applying a filter based on specific criteria, such as an Age field.

How to Filter Multiple Access Report Rows by Criteria

Product: Microsoft Access
Device & OS: not provided
Scenario: Creating or modifying an Access report to filter database records dynamically based on user input.
Observed behavior: The goal is to show all matching records for a specific field criterion on a report, allowing multiple rows to naturally display per page.

Before you start

Ensure you have your Microsoft Access database open and that you have already created the target form and report you wish to link.

Solution 1Recommended

Filter Access Reports Using Query Criteria Linked to a Form

Use a query as the report's record source and set the criteria to reference a specific control on an open form.

By linking your report's underlying query to a form control, you can dynamically filter the data before it loads. The report will automatically display all matching records, flowing multiple rows onto each page depending on your detail section's height.

Create a new Query

Go to the Create tab and click Query Design. Add the tables or queries containing the fields you want to display in your report.

Enter the form control reference

In the Query Design grid, locate the Criteria row for the field you want to filter by (for example, Age). Enter the syntax: =Forms!YourFormName!YourControlName (replacing 'YourFormName' and 'YourControlName' with your actual database object names).

Link the report to the query

Save the query. Open your report in Design View, open the Property Sheet, and set the Record Source property to the query you just created.

Run the report

Ensure your criteria form is open in Form View and contains a value. Run the report, and it will output multiple rows per page filtered strictly by the specified form criteria.

Form Must Remain Open: The form referenced in your query criteria must remain open (it can be hidden) when running the report. If it is closed, Access will prompt you for a parameter value.

Free Microsoft Office alternative

Switch to WPS Office for Your Daily Document Tasks

While Microsoft Access handles advanced relational databases, most of your daily workflow involves documents, spreadsheets, and presentations. WPS Office is a highly compatible, free, and lightweight alternative to Microsoft Office that easily handles Word, Excel, PowerPoint, and PDF files all in one streamlined interface.

1. Download the software: Visit the official WPS Office website and click the free download button for your operating system.
2. Install WPS Office: Run the downloaded installer and follow the quick setup instructions to integrate the suite onto your device.
3. Open your files instantly: Launch WPS Office and seamlessly open your existing Word, Excel, and PowerPoint files to continue working immediately.

Fully compatible with Microsoft Office formats like .docx, .xlsx, and .pptx without layout loss.Lightweight design that runs smoothly on almost any computer or operating system.All-in-one suite combining documents, spreadsheets, presentations, and PDFs in a single tabbed interface.Free to download and use with an intuitive, familiar user interface requiring zero learning curve.

Frequently Asked Questions

Why is Access prompting me for a parameter value when I open the report?

This usually happens if the form referenced in your query criteria is closed, or if the form/control name is misspelled in the criteria row. Ensure the form is open in Form View and the object names are typed exactly as they appear in the database.

Can I filter an Access report using multiple criteria simultaneously?

Yes, you can add multiple criteria references (e.g., Age and City) in the Query Design view. Place them on the same Criteria row for an 'AND' condition, or on separate rows for an 'OR' condition.

How do I ensure multiple records display on a single report page?

By default, a tabular or columnar report layout handles continuous records. Check the report's Page Setup and ensure the Detail section's height in Design View is small enough so that multiple rows physically fit on a standard printed page.

Office Quick Solutions