action query and new line command

[Dan]

I have an action query that is updating a text field. I
want it to equal the orriginal value & and new line & a
new sting. This is what I have so far:

UPDATE [Status Members] SET [Notes] = [Notes] &
newLineCommand & "Letter1"
WHERE ...

 

[Dirk Goldgar]

I have an action query that is updating a text field. I
want it to equal the orriginal value & and new line & a
new sting. This is what I have so far:

UPDATE [Status Members] SET [Notes] = [Notes] &
newLineCommand & "Letter1"
WHERE ...

UPDATE [Status Members]
SET [Notes] = [Notes] & Chr(13) & Chr(10) & "Letter1"
WHERE ...