Records Disappear in Blank Query

[Caryn]

I have a database with a few relationships in it. The patient and their
dependants are in two separate tables. I have been attempting to create
report from these tables by using a query, however after much trial and error
I have found that entire records are missing from the query. If I run a
query with all the information needed, but with no parameters these records
are still missing. Any ideas?

 

[Caryn]

It appears to have something to do with my dependants table. When I add the
info from that table these particular items disappear. The ones that
disappear do not have dependants, however other records without dependants
appear on the query.

 

[Adam Simpson]

You need a outer join between the two tables.
In the query builder right click on the joining line between the two tables.
Select the option that sais something like "Include ALL records from
'Patient' and only those records from 'Depentant' where the joins are
equal."
Do not specify any criteria on the Depentant table, or if you do you must
add something like "criteria Or Is Null".

Adam

 

[Caryn]

That fixed it! Thanks so much!

You need a outer join between the two tables.
In the query builder right click on the joining line between the two tables.
Select the option that sais something like "Include ALL records from
'Patient' and only those records from 'Depentant' where the joins are
equal."
Do not specify any criteria on the Depentant table, or if you do you must
add something like "criteria Or Is Null".

Adam






.