Others

Fix a Microsoft Access Query That Does Not Show New Records

Rana GarciaRana Garcia Nov 20, 2026 869 views

Question details

The user needs newly added table records to appear in a query based on two Access tables.

Fix a Microsoft Access Query That Does Not Show New Records
Product
Microsoft Access
Device & OS
not provided
Scenario
A query combines records from two tables using joined fields and may apply criteria.
Observed behavior
New records do not appear after the query is refreshed or rerun and its join properties are changed.
Before you start

Open the affected tables and query in Microsoft Access. Identify a missing record and note the values in its joined fields so you can compare them with the query design.

Solution 1Recommended

Correct mismatched field values and query criteria

Use this method when new records are excluded because of a typo, a missing join match, or a query criterion.

1
Inspect the query design

Right-click the query in the Navigation Pane and select Design View. Identify the line connecting the tables and the fields that have entries in the Criteria row.

2
Compare the joined values

Open each source table in Datasheet View and compare the joined field values for a missing record. Look for typos, extra spaces, or a value that has no matching record in the other table.

3
Check the criteria

Return to the query's Design View and compare each Criteria entry with the missing record. Correct any unintended spelling, value, or condition that excludes the record.

4
Correct and retest

In the affected table's Datasheet View, correct any confirmed typo and save the record. Close and reopen the query, or click Run in Design View, to check the results.

Correct mismatched field values and query criteria
Resolution in the reported case: Correcting typos in the relevant field of the affected records made them appear when the query was reopened.
Free Microsoft Office alternative

Review Access data in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Export Access query results to Excel to review them in WPS Spreadsheets; WPS does not fix Access joins or replace Access database queries.

Review exported query results in a spreadsheetCompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does refreshing the query not show a new record?

Refreshing cannot make a record match an incorrect join value or a criterion that excludes it. Open the query in Design View and compare the joined fields and criteria with the missing record.

How can I see records that have no match in the other table?

In Design View, double-click the join line and choose the Join Properties option that includes all records from the table you want to preserve. Also check criteria on fields from the other table, because they can exclude unmatched rows.

Where can I inspect the query's SQL?

Open the query, then choose View and select SQL View. Review the JOIN and WHERE clauses for matching conditions and filters.

Can WPS Office repair an Access query?

No. Correct Access table values, criteria, and joins in Microsoft Access. You can export query results to an Excel file and open that file in WPS Spreadsheets for review.