access update query

update query please

i have a column in dbse which contains some numbers say 1 22, 30 38

they may go up to 100 in due course or more
i want to devise a query that will change a group of them

say all the 10 s in the column to 12 or some other number of operators choice

help ppl
topUKlawyerAsked:
Who is Participating?
 
topUKlawyerConnect With a Mentor Author Commented:
many thanks i have resolved it myself with two sets of criteria [old number] and [new number]

which allows me to enter in a value for the updates as ans when we need them.
0
 
lee555J5Commented:
What are those numbers -- "1 22, 30 38"?
Did you mean
1
22
30
38
etc.
?

If so, try this
UPDATE table_name
SET column_name = 12
WHERE column_name = 10;

Open in new window

Lee
0
 
topUKlawyerAuthor Commented:
hit on it by chance!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.