Others

Fix Microsoft Access Records Missing from Tables but Visible in Queries

Algirdas Jasaitis Sep 25, 2026 869 views

Question details

Specific database records are visible when running a query but cannot be found when viewing the underlying source table.

How to Find Microsoft Access Records Missing from Tables but Visible in Queries

Product: Microsoft Access
Device & OS: not provided
Scenario: Viewing, filtering, or attempting to edit data records within a Microsoft Access database.
Observed behavior: Records successfully display in query results but remain hidden in the source table view, or joined query results are rendered read-only and prevent direct editing.

Before you start

Ensure you have the necessary database permissions to modify table views and access query design structures before attempting to change data filters.

Solution 1Recommended

Clear Active Filters in Table Datasheet View

Records are often simply hidden from the table view because a filter has been applied and saved to the layout.

Table-view settings in Access retain previous filtering options. Clearing these filters reveals the complete dataset that the query is pulling from.

Open Datasheet View

Double-click the underlying table in the Navigation Pane to open it in Datasheet view.

Navigate to Sort & Filter

Select the 'Home' tab on the top ribbon and locate the 'Sort & Filter' group.

Toggle or Clear Filters

Check if the 'Toggle Filter' button is highlighted. Click 'Advanced' and select 'Clear All Filters' to remove any hidden search criteria and display all records.

Clear Active Filters in Table Datasheet View

Verification: Once the filters are cleared, scroll through or search the table again to verify that the missing records now appear.

Solution 2

Check Query Join Types and SQL Design

If you cannot edit the records in the query result, the query might be using complex joins that render the dataset read-only.

Free Microsoft Office alternative

Switch to WPS Office for Effortless Data Management

If you find complex relational databases like Microsoft Access difficult to troubleshoot, consider using WPS Spreadsheet for your daily data tracking. It offers a lightweight, highly compatible alternative for managing tabular data without complicated queries or join properties.

1. Download the Installer: Visit the official WPS Office website and download the free installation package.
2. Export Access Data: In Microsoft Access, export your tables as CSV or Excel (.xlsx) files.
3. Open with WPS Spreadsheet: Launch WPS Office and open your exported files to seamlessly manage your data with intuitive spreadsheet tools.

Free and lightweight alternative to Microsoft OfficePerfect for tracking data and replacing complex Access tables with easy-to-use SpreadsheetsFully compatible with Microsoft Excel (.xlsx) and CSV formats for seamless data migrationFamiliar tabbed interface with zero learning curve for immediate productivity

microsoft office alternative - wps office

Frequently Asked Questions

Why are my Microsoft Access query results read-only?

Query results become read-only if the query relies on multiple tables without clearly defined primary key relationships, uses aggregate functions (like SUM or COUNT), or incorporates certain types of outer joins.

How do I view the actual SQL text of my query?

To view the SQL text, right-click your query and open it in Design View. Then, go to the Home tab, click the View dropdown arrow in the top left corner, and select 'SQL View'.

Can I recover a record I accidentally deleted from an Access table?

No, once a record is deleted in Microsoft Access and you accept the warning prompt, the deletion is permanent. You can only recover it if you have a prior backup of the database file.

Office Quick Solutions