Converting records into a text string

[Guest]

is it possible to create a text string, separated by a ";", from records in a
table. I am trying to take the email values in a table and combine them into
one string of text so I can pass it to the "To" field in Outlook.

Thanks,

PS this is the best support site I have dealt with. Great job!!!

 

[Duane Hookom]

There is a generic Concatenate() function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
You can specify the delimiter to be ";" in the function call.

 

[John Nurick]

Hi Eli,

Go to www.mvps.org/access and search for "concatenate". You'll find a
function there that does the job, though I think you'll have to modify
the code to use ";" instead of ","

 

[Guest]

Or you could try:
Select field1 & ';' & field2 & ';' & field3...... from table;

 

[Guest]

Thank you very much.

Hi Eli,

Go to www.mvps.org/access and search for "concatenate". You'll find a
function there that does the job, though I think you'll have to modify
the code to use ";" instead of ","

 

[John Nurick]

That concatenates values in multiple fields from the current record;
Eli's question implied concatenating values in one field of multiple
records.