View Single Post
  #1  
Old May 25th, 2010, 12:50 AM posted to microsoft.public.access.queries
Paul
external usenet poster
 
Posts: 126
Default adding a Carriage Return or Line Feed character to an update query

I'm building an update query that will concatenate two fields and update the
first field with the combination of the two fields. However, I would like
to separate the two components with a blank line, or two carriage return or
line feed characters. In Visual Basic, I'd use vbcr&vbcr to do this. How
can I do this in an update query?

Thanks in advance,

Paul