Update Rows in Table

J

Johnson

I have a table where I need to update Column X with a
certain number and then each record below it add 1.

For example.

Record 1 needs to be 45600012
Record 2 needs to be 45600013
Record 3 needs to be 45600014

How do i go about writing a query that will update the
fields this way.

Any advice would be helpful!

Thanks so much :)
 
S

Steve Schapel

Johnson,

Some may regard this as being crude, but here goes... Add (temporarily)
an autonumber field to your table, let's say it's called TempAutoNumber,
then make an Update Query based on your table, and update Column X to
45600011+[TempAutoNumber]
 
Top