Fix a Microsoft Access Query That Does Not Show New Records
Question details
The user needs newly added table records to appear in a query based on two Access tables.

- 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.
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.
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.
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.
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.
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.
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.

Review the join type for unmatched records
Use this method if the query should include records from one table even when there is no matching record in the other.
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.

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.




