Others

How to Fix Microsoft Access Query Showing No Data When Joining Tables

Maira Mehtab Sep 20, 2026 870 views

Question details

An Access query joining a query-based table and a calculation table results in an entirely empty dataset in the table view.

Product: Microsoft Access
Device & OS: not provided
Scenario: Creating a joined query to merge master data with calculations, intending to filter and export the results to Excel.
Observed behavior: The joined query view displays no data because the relationship or link properties between the two tables are incorrectly configured.

Before you start

Double-check the data types of the fields you are attempting to join; mismatched data types (e.g., Short Text vs. Number) will cause queries to fail or return no data.

Solution 1Recommended

Modify Query Join and Link Properties

Adjusting the join type between the tables resolves empty results caused by mismatched or strictly filtered inner joins.

By default, Access creates an Inner Join, which requires matching data in both tables to display a row. If the calculation table lacks corresponding records, the query will hide the master table's records as well.

Open Design View

Open your database in Microsoft Access, right-click the problematic query in the Navigation Pane, and select 'Design View'.

Access Join Properties

Locate the relationship line connecting Table 1 and Table 2 in the upper grid. Double-click the middle of this line to open the 'Join Properties' dialog box.

Change Join Type

Review the joined fields. Select option 2 or option 3 (Left or Right Outer Join) to include all records from your primary master table, even if the calculation table contains no matching data.

Test the Query

Click 'OK' to save the properties, then click the 'Run' (!) button in the Query Design ribbon to verify that the table data now populates correctly.

Solution 2

Calculate and Export Directly from Queries

Streamline your database workflow by performing calculations directly within queries and exporting them, bypassing the need to generate intermediate tables.

Free Microsoft Office alternative

Analyze Exported Access Data Seamlessly with WPS Office

Since database structure issues like Access query joins require native Microsoft Access troubleshooting, WPS Office serves as the perfect companion for the next step of your workflow. Once your data is successfully exported, use WPS Spreadsheet as a free, lightweight, and highly compatible alternative to Microsoft Excel for analyzing, charting, and sharing your results.

1. Export Data: Export your corrected Microsoft Access query results directly as an .xlsx file.
2. Open in WPS Spreadsheet: Launch WPS Spreadsheet and open the exported file to view your database records.
3. Analyze Results: Use built-in PivotTables, charts, and conditional formatting to further analyze your query results effortlessly.

High compatibility with Microsoft Excel (.xlsx and .xls) formats for exported Access dataLightweight architecture handles large datasets and queries smoothly without laggingFree advanced formulas and pivot tables for secondary data calculationsFamiliar user interface ensuring a seamless migration and zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does changing the join type fix an empty query result?

By default, Access creates an Inner Join, which only displays rows where there is an exact match in both tables. If your secondary table lacks matching records for the primary table, the entire row is hidden. Changing it to an Outer Join forces all primary records to appear regardless of matches.

Do I need to create a separate make-table query to export results to Excel?

No, it is highly recommended to export standard Select Queries directly. Creating additional physical tables bloats the database and complicates the workflow. Simply right-click any saved query in the Navigation Pane and choose the Export option.

How can I handle query exports that exceed Excel's maximum row limit?

If your data exceeds Excel limits (over 1,048,576 rows), use aggregate functions in your Access query to summarize the data first. Alternatively, use Access VBA or intermediate queries with date parameters to filter and split the data into multiple manageable exports.

Office Quick Solutions