Update query

[soundsfishy]

I need to update a column in table which currently has numeric values eg 1 , 2, 5 so on that a user select stating which studio was used. I need to have the values displayed as Studio 1 , Studio 2 etc.

what do I put in the criteria part of the query and the Update to inorder to change the existing values in my table.

 

[R. Hicks]

Use the following as the "Update To":

"Studio " & [YourFieldName]

Change "YourFieldName" to the actual name of the field you want to update.

HTH
RDH

 

[soundsfishy]

Thanks rick,

I had a go but got a bit stuck becuase I havent really used any update query. If u see below will see what I am trying to achieve.



My table looks a bit like this

ID : Studio DateBooked
---------------------------
1 1 20/12/02
2 6 02/01/03
3 5 02/01/03
4 5 02/01/03

I want change the value include studio in the front of the value.

ID Studio DateBooked
------------------------------
1 Studio1 20/12/02

 

[Kent Tschoepe]

Make sure the field "studio" is a text field with at least 10 characters. Then design an update query with the "studio" field and in the "update to" space type "Studio " & [studio]. The Studio in quotes is going to add the word Studio to the value in your field [studio]. Run it. One easy way to remember how update queries work is to change the words "update to" to "change to" in your mind when you read your query. In other words, the value "1" will change to "Studio 1".

 

[soundsfishy]

Thanks for that. It worked.

What I didnt doing was change the number field to a text field.