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

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a Hard Return or carriage return in an update query? 1
Query returns Arabic and/or sanskrit characters 4
Carriage Return in an Update Query 4
how do I embed a line feed in a memo field via Query 2
Update querry to memo field - How do I add a carriage return? 4
Adding a carriage return in a query 4
Carriage Return Error in Concatenated Field 2
Carriage Return or Line Feed 1

Top