how to view single record of ALL people at single address?
I have a table with addresses and names. I can easily sort it by address to see all the people living at the same address grouped together. However, this is problematic with mail-merges, since I wind up generating a new letter for each person, sending multiple mailings to the same residence.
Here is what the table looks like:
Name Address
===== ==========
Mary 101 Franklin Ave
John 101 Franklin Ave
Andrew 101 Franklin Ave
Matthew 101 Franklin Ave
Tim 2 Main St
Mark 2 Main St
Sam 2 Main St
Is there a way I can use a query combine all the names into a single "virtual" field, so that I only have one row for each address?
Here is what I would like to see:
Name Address
============= =================
Mary, John, Andrew, Matthew 101 Franklin Ave
Tim, Mark, Sam 2 Main St