Change Query output from Vertical list to Horizontal Delimited by Semicolons

  • Thread starter Thread starter Les
  • Start date Start date
L

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
 
Thanks Allen


Allen Browne said:
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.

Les said:
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]
Click to expand...
Click to expand...
 
Back
Top