adding text with update query

  • Thread starter Thread starter Lauri
  • Start date Start date
L

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.
 
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.
Click to expand...
Create an Update query.

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