A
Amanda Byrne
I have a Household table and a People table. The Household table has a
record for each address, the people table has a record for each person and an
associated Household ID.
I need to append a field in the Household table based on the number of
people living at that address. I plan to write a separate append queries for
individuals, couples, and "families". So I need select statements that will
return data from my people table where 1)there is only one person in the
household, 2)there are 2 people in the household, and 3) there are 3 or more
people in the household.
How to go about?
Thanks, Amanda
record for each address, the people table has a record for each person and an
associated Household ID.
I need to append a field in the Household table based on the number of
people living at that address. I plan to write a separate append queries for
individuals, couples, and "families". So I need select statements that will
return data from my people table where 1)there is only one person in the
household, 2)there are 2 people in the household, and 3) there are 3 or more
people in the household.
How to go about?
Thanks, Amanda