How to append more lines at the end of a memo field?
I have table field called NOTES which I use to write various notes, sometimes the same note is stretched across several records & I would like to be able to append it to the records using an update query. However, if any of the affected records already contain pre-existing notes then I’d like to be sure that the new note I append to the field adds an ENTER character before appending the new note, how do I do this though? I tried writing something like this in the UPDATE TO row of the query, but it doesn’t work.
VBCRLF & “This is the new note appended to the end of the note field”
Please advise.
I have table field called NOTES which I use to write various notes, sometimes the same note is stretched across several records & I would like to be able to append it to the records using an update query. However, if any of the affected records already contain pre-existing notes then I’d like to be sure that the new note I append to the field adds an ENTER character before appending the new note, how do I do this though? I tried writing something like this in the UPDATE TO row of the query, but it doesn’t work.
VBCRLF & “This is the new note appended to the end of the note field”
Please advise.