Adding carriage returns to a concatenated string in an update query

[jurroppi1]

I'm trying to get the update to field in an update query to keep the existing data and add a comment to it using an update query. the field I am appending to is called "RootCause".

the problem I am having is that I cannot figure out how to concatenate a CRLF between the existing string and the string I want to concatenate to the field. Currently I am able to get the existing string and another string concatentaed together without issue, but the carriage return linefeed item eludes me. Is there a way to do this without having to write a vbscript routine?

So far I've tried the following:
[RootCause] & Chr(10) & "7/18/2008 - TEST"
[RootCause] & Chr(13) & "7/18/2008 - TEST"
[RootCause] & Chr(10) + Chr(13) & "7/18/2008 - TEST"
[RootCause] & vbCrLf & "7/18/2008 - TEST"
(in the last example Access want to put quotes around the vbCrLf statement (I saw an example of this in another post entitled "Carriage Return Syntax to make address label".

thanks in advance for any help on this.

 

[huh?]

try putting the following in the "Update To:" section for the field, [RootCause] in the Query Design grid view of your update query:

[RootCause] & Chr$(13) & Chr$(10) & "7/18/2008 - TEST"

Hope this helps.

 

[jurroppi1]

Works like a charm... Thank you so much for the help!

Where did you come up with the information to add the "$" modifier to the Chr function?

I swear that the help file for Access is pretty nebulous sometimes.

 

[huh?]

You're very welcome.
I googled it, using search criteria, ms access query carriage return line feed, or something similar and then tested it.
Both Chr and Chr$ will work. What matters is the order you put them in. In other words you have to put Chr(13), carriage return, and then Chr(10), line feed. Otherwise you get some strange characters added to the line. At least that is how it works in access 2003.