Need help with SQL statement. I need to add 30000 to values in an Autonumber field. How should it look?

Question

I have:

Select *
From TableName
WHERE (((TableName.ValueID)>=1000));

But then whats next? How do I increase all values over 1000 to 31000 etc?

Please advise.

thx

Answer 1

You can simply use the below query to achieve the desired result:

UPDATE TableName
SET TableName.ValueID = TableName.ValueID+ 30000
WHERE TableName.ValueID >= 1000

Answer 2

Update TableName Set ValueID=ValueID + 30000 where ValueID>=1000

Answer 3

For the actuality you want to declare which columns you're putting them into otherwise it tries to insert the values into all columns. modify your code to the lower than: INSERT INTO poll (question) VALUES ('attempt')