Thread: Need help with concatenation function
View Single Post
  #5  
Old May 21st, 2010, 08:34 PM posted to microsoft.public.access.queries
EllenM
external usenet poster
  
Posts: 206
Default Need help with concatenation function
Thanks, John

And change:
fConcatFld = Left(lovConcat, Len(lovConcat) - 2)

to
fConcatFld = Left(lovConcat, Len(lovConcat) - 8)

Now it's a masterpiece.