Others

Fix Quick Filter Problems in Microsoft Access Tables

Emma BrownEmma Brown Nov 22, 2026 868 views

Question details

The user needs a way to use quick filters reliably on a table created by a make-table query.

Fix Quick Filter Problems in Microsoft Access Tables
Product
Microsoft Access
Device & OS
not provided
Scenario
Filtering different values in the same column of a table created by a make-table query.
Observed behavior
The filter must be toggled before another value can be selected in the same column. Copying the data to a new table resolves the behavior.
Before you start

Open the database in Microsoft Access and note the name of the table created by the make-table query. You will use that name in a SELECT query.

Solution 1Recommended

Apply the quick filter to a SELECT query

Use a simple query as a workaround when quick filtering behaves inconsistently on the table itself.

1
Create a query

In Access, select Create > Query Design. Close the Show Table or Add Tables pane if it opens.

2
Enter the SQL statement

Switch to SQL View and enter SELECT * FROM [YourTable];, replacing YourTable with the actual table name.

3
Run the query

Select Run on the Query Design ribbon to display the table's records in Datasheet View.

4
Filter the query results

Open the drop-down arrow in the column header and select the values to display. Use the same drop-down to change the selection.

5
Save the query

Press Ctrl+S and give the query a name so you can reopen it for filtering.

Apply the quick filter to a SELECT query
Workaround scope: Filtering through a query may provide more reliable behavior, but it does not change the underlying table or guarantee that the issue will disappear.
Free Microsoft Office alternative

Filter exported Access data in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface and support for Microsoft Excel files, making exported table data easy to move and filter. It does not repair Microsoft Access or replace an Access database.

  1. 1. Export the Access table: In Access, select the table and choose External Data > Excel in the Export group. Choose an XLSX file location and complete the export.
  2. 2. Open the exported file: Open WPS Spreadsheets and use Open to select the exported XLSX file.
  3. 3. Enable filters: Select the data range, including its headers, and choose Data > Filter.
  4. 4. Choose column values: Use a column header's filter arrow to select the values you want to display.
Filter exported table data using spreadsheet column filters.Open and edit Microsoft Excel XLSX and XLS files.Use a familiar spreadsheet interface to ease migration.Work with a free, lightweight Office alternative.
microsoft office alternative - wps office

Frequently Asked Questions

Why use a query instead of filtering the Access table directly?

A simple SELECT query displays the table's records in a query datasheet, where quick filtering may behave more reliably. Create one in Create > Query Design and enter SELECT * FROM [YourTable]; in SQL View.

Does the SELECT query create another copy of the table?

No. SELECT * FROM [YourTable]; displays records from the existing table; it does not create a new table.

How do I change the filtered value in the query?

In the query's Datasheet View, select the drop-down arrow on the column header, change the selected values, and apply the filter.

Can copying the data to a new table help?

In the reported case, copying the data to a new table resolved the behavior. Before relying on a copied table, check its field types, indexes, and relationships, as these may not match the original.

Can WPS Office open an Access database as a database?

WPS Office does not replace Microsoft Access. To filter a standalone set of records in WPS Spreadsheets, export the Access table to an Excel file using External Data > Excel, then open the exported file in WPS.