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.
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.