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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top