Novice Question - I wish to modify the data in multiple feilds

[Zaphod Beeblebrox]

Hi There;

This is a silly question but I have to ask this.

I want to create a query (SQL statement would be good!) that will do
the following:

1. modify the data in the field of my choice;
2. but keeps the present data intact.

Example: In the field "Subject" , I have "Test One - do this" . I want
to modify ALL of the "Subject" fields to have (current data) + " and
then do this"

Am I being clear? What SQL command would one use for this??
Examples??

Thanks

Z

[MLH]

Prepending or Appending a string to another string is easy. Your
query shows the field names in the QBE grid. If a field name is
[MyTest] then use an UPDATE query to update [MyTest] to
[MyTest] & " and then do this"

xxxxxxxxxxxxxxxxxxxxxxxxxx

Example: In the field "Subject" , I have "Test One - do this" . I want
to modify ALL of the "Subject" fields to have (current data) + " and
then do this"

Am I being clear? What SQL command would one use for this??
Examples??

Thanks

Z

[Zaphod Beeblebrox]

Hey...thank you SO much for your help! I was just getting the syntax
wrong but you put me in the right direction!

Thanks again!

Z