Remove line feeds in a report

There is a generic concatenate function with a demo at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane

--
Duane Hookom
MS Access MVP


"CCW" wrote in message
...
I need output that puts email address together based on a query so I can
cut and paste them to the TO line of any email client. The output from
Access needs to look like
; ; ...etc.
It has to display on the screen in a manner that allows cutting and
pasting. Perhaps outputting to a text file that will open after the data is
generated. Use the email address shown without the .INVALID at the end.
Thank you