question

  • 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. I have a different form
attached to each of the 3 different tables. It seems that
if data isn't entered in one of the forms none the data
shows in the query. How would I fix this?

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

By changing your Query. A normal multitable query retrieves a record
only when there is matching data in all of the joined tables; if one
table has no matching records, you won't get anything at all.

One thing to investigate is to click the join line in the query design
window. Choose the Join Type 2 or 3 - "show all records in <one table>
and matching records in <related table>". This might not work for
three tables if there is no relationship between the second and third
tables, post back if you have problems with it.
 
Back
Top