All people at a single address for labels

[Guest]

I've been learning Access andhave been pretty successful with it for the last
two months, using a lot of its capabilities.

Now I need to do something and I can't figure out how to do it. I have a
database of community residents and each resident has a primary Key ID.
Obviously, there are many cases where more than one person (i. e. husband and
wife) live at the same address. I need to do a mass mailing and postage is
expensive, so I wanted to combine these into one mailing label, perhaps
creating a LABEL TABLE. Up to two names could be used on one label.
-Person 1
-Person 2
-Street
-City, State ZIP

I've created a table with all the unique addresses by specifiying "DISTINCT"
for the output table. Now what do I do? I was thinking I'd find all the
RESIDENTS for a particular address and then pull them off, two at a time, to
the LABEL TABLE along with the mailing address. But I can't figureout how to
do it.

Thanks for any suggestions.

 

[Duane Hookom]

You could create a main report of the distinct addresses and a subreport of
the related residents.
Another option is the generic concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane