Household mailing

[donaldc]

Hi all,



First post here, but I'm fairly new to Microsoft Access. I have a database with a table for persons with FirstName and LastName with each person being a different record; a table for households that links to each person; and a table for addresses.

I would like to make a query to create mailing lables by combining LastName if they are the same and in the same household (the Household is linked to the addresses) but not combine LastName if they are different but still in the same Household. Here's an example of what I would like to do:

FirstName LastName Household
John Doe 1
Jane Doe 1
Tom Smith 2
Ashley Bennett 2


For household 1:
John and Jane Doe
1234 5th Ave

For household 2:
Tom Smith and Ashley Bennett
5678 9th Ave

[Siiig]

Nifty, this actually worked out for me.

I've re-created data into a table similar to how you described, but excluded the "Households" table.

I'm left with two tables. The person's table, which includes first / last / house hold ID, and the Addresses table, which I've built as Litteral Address / Household ID


In my query I've linked the two tables together by the "Household ID" column, then added the Last Name and Address to the query.

I jumped over the the SQL "view" and added DISTINCT after SELECT to make...

SELECT DISTINCT donPeople.LastName, donAddresses.Address
FROM donAddresses INNER JOIN donPeople ON donAddresses.ID = donPeople.Household;




Just a quick example of my results...

LastName	Address
Doe	123 Fake Street
Smith	456 7th Ave
Williams	456 7th Ave