How to sum text strings from the same field of 1-7 query records?

[Guest]

Hi,
I have to mail out cards to people who are identified by a monthly query.
The card has a message that has to incorporate the text content of a field
into the message body. A person may have more than one incidence of his name
in a query because there may be more than one diferent text content
associated to his name.
J Smith | table
J Smith | chair
J Smith | flower stand

The card should look like

Delivery of table, chair and flower stand J Smith
is expectable within ten days Address
Best Regards
Your Company

How to concatenate the text values and
how to incorporate the sum of text into a message body?

Thank you for considering my problem
Joe

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.