Fix Quick Filter Problems in Microsoft Access Tables
Question details
The user needs a way to use quick filters reliably on a table created by a make-table query.

- 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.
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.
Apply the quick filter to a SELECT query
Use a simple query as a workaround when quick filtering behaves inconsistently on the table itself.
In Access, select Create > Query Design. Close the Show Table or Add Tables pane if it opens.
Switch to SQL View and enter SELECT * FROM [YourTable];, replacing YourTable with the actual table name.
Select Run on the Query Design ribbon to display the table's records in Datasheet View.
Open the drop-down arrow in the column header and select the values to display. Use the same drop-down to change the selection.
Press Ctrl+S and give the query a name so you can reopen it for filtering.

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. 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. Open the exported file: Open WPS Spreadsheets and use Open to select the exported XLSX file.
- 3. Enable filters: Select the data range, including its headers, and choose Data > Filter.
- 4. Choose column values: Use a column header's filter arrow to select the values you want to display.

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.




