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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Access 2007 / update query 1
Selectively Update Field in Table 2
Append Query Issue 0
update query 2
Help! Need to update linked SQL table in Acc07 3
Create update query for remaining records 10
Update table records 1

Back
Top