adding a Carriage Return or Line Feed character to an update query

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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
 
Chr(13) & Chr(10) work great.

My thanks to Marsh and Allen.

I used the expression

SET fld1 = fld1 & Chr(13) & Chr(10) & Chr(13) & Chr(10) & fld2

and it put a blank line in between the two concatenated fields, which is
exactly what I was trying to accomplish.

Paul
 
Back
Top