action query and new line command

  • Thread starter Thread starter Dan
  • Start date Start date
D

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 ...
 
Dan said:
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 ...
Click to expand...

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