Help: Query Output in a string

[RDMRDM]

I have a table with a field with email addresses. I would like to have my query results include all the email addresses separated by a comma.

Example:

Field Name: Email
Field Name entry examples:
JohnDoe@email.com
JaneDoe@email.com
JoeDoe@email.com

I would like the query results to be as follows: JohnDoe@email.com, JaneDoe@email.com, JoeDoe@email.com

Thanks in advance for any help.

 

[PHV]

Have a look here: faq701-4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886