Query Pulling from 3 Tables

D

Don S.

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
 
O

oozyscab via AccessMonster.com

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
 
Top