Update Rows in Table

  • Thread starter Thread starter Johnson
  • Start date Start date
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 :-)
 
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]
 
Back
Top