Concatenate / append field in UPDATE statement 1

[projecttoday]

Is there any way to concatenate a value onto a field as opposed to just overwriting it when using an UPDATE statement?

Instead of

UPDATE tblTable SET fld = "abc" WHERE fld2="b"

I want

UPDATE tblTable SET fld = fld & "abc" WHERE fld2="b"

 

[alvechurchdata]

UPDATE tblTable SET fld = fld & "abc" WHERE fld2="b"

Your syntax works for me. What happens when you try it?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[projecttoday]

I'll try it. Thanks.

 

[projecttoday]

By the way, thanking popups aren't coming up on my computer. And I didn't get an email for the response.

 

[projecttoday]

Popups are working now. Thanks.