adding text with update query

[Lauri]

Using Access 2000. I want to update the text in a field to include the text
that's already there and add two words.

<field> = <field> & " - cancelled"

It seems like it would be a simple request, but I'm stumped.

 

[fredg]

Using Access 2000. I want to update the text in a field to include the text
that's already there and add two words.

<field> = <field> & " - cancelled"

It seems like it would be a simple request, but I'm stumped.

Create an Update query.

Update YourTable Set YourTable.[FieldName] = [FieldName] & "-
cancelled";