Create lables that address all people at the same address. 1

[dawnd3]

I have a table of individuals and then a linked "family" table that has the address and other common infomation. However, now I would like lables that concatinate all of the first names on one mailing lable. So if their are 3 people at the Smith residence, it would say John, Mary and Sue Smith.

Thank you for your help.

Dawn

http://www.calliopeconsulting.net

 

[dhookom]

There is a generic concatenate function at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Let us know if you have trouble implementing this.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[dawnd3]

Duane, you are awesome!!! Thanks for sharing that, it worked great!

Dawn

http://www.calliopeconsulting.net