Others

How to Run Multiple Queries and Compare Records in Microsoft Access

Algirdas Jasaitis Sep 27, 2026 869 views

Question details

The user needs to display and compare multiple matching records simultaneously in Microsoft Access without one search result replacing another.

How to Run Multiple Queries and Compare Records in Microsoft Access

Product: Microsoft Access
Device & OS: not provided
Scenario: Searching, filtering, and comparing multiple records within a database form simultaneously.
Observed behavior: By default, viewing a single record might hide others, prompting the need for a layout or query configuration that allows viewing all matched records side-by-side or in a list format.

Before you start

Ensure you save any unsaved form or query designs before modifying their properties, and keep a backup of your database to prevent accidental data loss while adjusting SQL parameters.

Solution 1Recommended

Use Continuous Forms or Datasheet View

Instead of running multiple queries, use a single query that returns all matching records and display them in a Continuous Form or Datasheet to view them all at once.

This is the most efficient way to display multiple records without needing complex multi-query setups. It leverages Access's built-in form views to list everything cleanly.

Create a comprehensive query

Design a single query that captures all the records you want to compare and save it.

Create a form based on the query

Select the query in the Navigation Pane, go to the 'Create' tab on the ribbon, and click 'Form'.

Change the Default View

Switch to 'Design View', open the Property Sheet (F4), navigate to the 'Format' tab, and change the 'Default View' property to 'Continuous Forms' or 'Datasheet'.

View the records

Switch back to 'Form View'. All matching records will now be displayed simultaneously in a scrollable list.

Navigation Tip: You can use the built-in navigation bar at the bottom of the continuous form to easily jump between the returned records.

Solution 2

Create a Split Form for Detailed Comparison

A split form allows you to view a single detailed record while simultaneously viewing the entire list of results in a datasheet format.

Solution 3

Configure Optional Query Parameters for Dynamic Filtering

Modify your query's SQL view to allow flexible search criteria, making it easier to filter and match specific records without replacing the view.

Free Microsoft Office alternative

Manage Data and Track Records Effortlessly with WPS Office

While Microsoft Access is built for complex relational databases, many users find that filtering, comparing, and managing data records is much simpler using a powerful spreadsheet application. WPS Office provides a highly compatible, easy-to-use alternative to Microsoft Office for your daily data tracking needs.

1. Download WPS Office: Visit the official WPS Office website and download the installer for your operating system.
2. Install the application: Run the installation file and follow the simple on-screen instructions to set up the software.
3. Open your data files: Launch WPS Spreadsheet, open your exported data files, and use the built-in Data tab to filter and compare records instantly.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) and Word formats.Free, lightweight, and fast-loading across Windows, Mac, Linux, and mobile.Intuitive interface for effortless data filtering, sorting, and side-by-side comparison without requiring SQL knowledge.Seamless migration of your exported database records into ready-to-analyze spreadsheets.

microsoft office alternative - wps office

Frequently Asked Questions

Can I filter multiple values in a single field in Microsoft Access?

Yes, you can use a multi-select list box on your search form. This allows users to select several values at once. You will need to use VBA (Visual Basic for Applications) to loop through the selected items and build a dynamic SQL string for your query or form filter.

Why does my query only show one record at a time?

This usually happens if the form you are using to view the query is set to 'Single Form' view. Changing the form's 'Default View' property in Design View to 'Continuous Forms' or 'Datasheet' will display all matching records at once.

What does 'IS NULL' do in an Access query parameter?

Using 'IS NULL' in a parameter, such as (Field1 = [Param] OR [Param] IS NULL), ensures that if the user leaves the search box blank, the query will ignore that specific criteria instead of filtering for blank fields. This effectively makes the search parameter optional.

Office Quick Solutions