Missing Data

  • Thread starter Thread starter Penny
  • Start date Start date
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
 
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
 
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.
 
Back
Top