Change Query output from Vertical list to Horizontal Delimited by Semicolons

[Les]

As per title I have a query output which I need to change to a list
delimited by ; for email purposes.

Is there a simple way to do this?

My field name is [strEmail_Address]

Les

 

[Allen Browne]

See:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

 

[Les]

Thanks Allen

See:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

As per title I have a query output which I need to change to a list
delimited by ; for email purposes.

Is there a simple way to do this?

My field name is [strEmail_Address]