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?

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?