Missing Data

P

Penny

I'm pulling data from 4 fields from 3 different tables and
some of the data isn't showing on my query. I have a
different form attached to each of the 3 different tables.
It seems that if data isn't entered in on of the forms non
of the data shows in the query. How would I fix this?

Thanks
 
G

Guest

Change your join types to left outer joins. To do this,
right click on the join line in the query design grid and
then select the middle choice.

Stan
 
S

Sirocco

If the field used to join 2 tables is null on the "many" side, the entire
record won't be in the result. If this data needs to be viewed you should
replace the null values with the correct data to match up the record with
the parent record on the "one" side of the relationship.
 
Top