If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Records Disappear in Blank Query
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? |
#2
|
|||
|
|||
Records Disappear in Blank Query
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. "Caryn" wrote: 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? |
#3
|
|||
|
|||
Records Disappear in Blank Query
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" wrote in message ... 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. "Caryn" wrote: 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? |
#4
|
|||
|
|||
Records Disappear in Blank Query
That fixed it! Thanks so much!
"Adam Simpson" wrote: 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" wrote in message ... 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. "Caryn" wrote: 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? . |
Thread Tools | |
Display Modes | |
|
|