Fix Microsoft Access Queries Returning No Results After Import
Question details
Identify why imported records appear in an Access table but do not appear in a query joined to another table.

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

Test the join and query criteria in Access Query Design
Use a left join and temporarily remove filters to distinguish unmatched records from records excluded by criteria.
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.

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.




