Query Pulling from 3 Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am pulling data from 3 tables and it is possible a report may be pulled
executing this query when no record has yet been created in one of the
tables. When this happens an error is shown on the report.

Two tables are joined to the main table by an ID# and the joins are #1.

How can I fix the query to pull data from two of the tables if the third
does not have an associated record?

Thanks
 
The easiest way to overcome this problem is to change the join properties in
the query to always pull data from the table that will always have data and
then only show matching data from the other tables.

Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Have both records from two queries/tables under one Query without related fields. 0
Left join in query 12
Use the Second Max Value in a Formula???? 4
Two Table Query 4
Query that references a field ID(P_K) to filter data from other ta 1
Append Query and Combo Lookup Problems 1
Combine Duplicates in Query 0
Access Query to list data on table but not on another table? 2

Back
Top