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
|
|||
|
|||
Report does not contain all the records I expect
I have three tables (Contacts, Children, Other Adults). They are all related
by the ContactID. Not all contacts have children, some have more than one adult in the family, not all have other adults. I wanted a report that included all adults and all children for each contact. I created a query of Contacts and their children and tried to insert a subreport of the other adults. It worked but only contained half of the contacts in my original table. Can you tell me what the problem might be? |
#2
|
|||
|
|||
Report does not contain all the records I expect
You need to LEFT JOIN Contacts to Children and Other Adults tables.
If you need more assistance the post the query or report SQL. -- Build a little, test a little. "Mary" wrote: I have three tables (Contacts, Children, Other Adults). They are all related by the ContactID. Not all contacts have children, some have more than one adult in the family, not all have other adults. I wanted a report that included all adults and all children for each contact. I created a query of Contacts and their children and tried to insert a subreport of the other adults. It worked but only contained half of the contacts in my original table. Can you tell me what the problem might be? |
Thread Tools | |
Display Modes | |
|
|