Family Listing

T

Taso

Im working on a mailing list in access, and I am trying
to make a family list, the only issue is I have siblings
and parents on the list and I am trying to figure out how
to make the query only report once per household.
Does anyone know how I can pull that off?
 
J

John Vinson

Im working on a mailing list in access, and I am trying
to make a family list, the only issue is I have siblings
and parents on the list and I am trying to figure out how
to make the query only report once per household.
Does anyone know how I can pull that off?
Click to expand...

What I've done in this situation is to have two tables: tblFamilies,
which contains the mailing address, related one to many to tblPeople.
tblPeople contains a FamilyID field as a link to the family table.

I've given a few people a free copy of my church-membership database
which incorporates this feature (together with an unlimited number of
mailing lists). Let me know if you would like a copy (and what Access
version you use if so).
 
T

Taso

That would be real cool if you could do that.
just remove the **NOSPAM** in my email address.

Thanks
 
Top