View Single Post
  #2  
Old May 21st, 2010, 07:18 PM posted to microsoft.public.access.queries
Bob Barrows
external usenet poster
 
Posts: 475
Default Need help with concatenation function

EllenM wrote:
Hello,
I've found a wonderful concatenation function at
http://www.mvps.org/access/modules/mdl0008.htm. It, however,
separates the concatenated values with semicolons when I'd like them
to be separated with "br /"s.

For instance, instead of "Value1; Value2; Value3", I'd like
"Value1br / Value2br / Value3br /".

Thanks in advance for your help.

Ellen


I don't have the function in front of me, but surely it can't be too hard to
change the '& ";" 'bit to '& "br /"'

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"