Others

Fix Microsoft Access Queries Returning No Results After Import

Amos GikundaAmos Gikunda Nov 22, 2026 868 views

Question details

Identify why imported records appear in an Access table but do not appear in a query joined to another table.

Fix Access Queries Returning No Results After Import
Product
Microsoft Access
Device & OS
not provided
Scenario
Reviewed data is imported back into Access and queried alongside a related table.
Observed behavior
A query using only the imported table returns records, but a query joining it to another table returns no results.
Before you start

Open the database and identify the two tables and fields used in the join. Confirm which records were imported and whether the import appended or replaced data.

Solution 1Recommended

Compare and clean the join fields in both tables

Use this method when records exist in the imported table but their join values do not match the related table.

1
Inspect the imported records

Open the imported table from the Navigation Pane in Datasheet View. Check that the expected records and join-field values are present, and determine whether the import added records or replaced existing data.

2
Compare field data types

Open each table in Design View and compare the Data Type and, where applicable, Field Size of the join fields. Make sure the fields are compatible, such as an AutoNumber key and a Number field with the Long Integer field size.

3
Check the actual values

Open both tables in Datasheet View and compare corresponding join values for leading or trailing spaces, hidden characters, leading zeros, and other formatting differences. In a test query, use Len([JoinField]) and Trim([JoinField]) on text fields to help identify extra spaces.

4
Correct the mismatch and retest

Correct the source data or import settings, then reopen the joined query and select Run. Preserve meaningful values such as leading zeros when choosing how to store or clean the fields.

Compare and clean the join fields in both tables
Text matching: Access text comparisons are generally case-insensitive, so check spaces, hidden characters, and data types as well as capitalization.
Free Microsoft Office alternative

Review exported documents with WPS Office

WPS Office is a free, lightweight alternative for reviewing exported documents and spreadsheets in a familiar interface. Its Microsoft Office format support can make migration easier, though it does not fix Access database joins.

Review exported Word documents with WPS WriterOpen and edit Microsoft Word DOCX and Excel XLSX filesUse a familiar interface for everyday document and spreadsheet workMove common Office files into a lightweight productivity suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access query return records from one table but not when I add a join?

An inner join returns only rows with matching join values. In Query Design, check the join fields and compare their data types and actual values in both tables.

How can I see which imported records have no match?

In Query Design, double-click the join line and select the Join Properties option that includes all records from the imported table. Run the query without criteria that filter the other table; unmatched rows will have empty fields from that table.

Can extra spaces prevent Access join fields from matching?

Yes. Leading or trailing spaces and other hidden characters can make text values differ. Compare the fields in Datasheet View or use Len and Trim in a test query to investigate.

Can WPS Office repair an Access query?

No. Troubleshoot the join and import in Microsoft Access. WPS Office can help review exported Word documents or Excel spreadsheets, but it does not repair Access database queries.