update new field with sequential number

[ibjolley]

I have a 100k record table in Access 2002 with a new field which needs to be updated with a sequential number. Basically, I need to insert the rownum into this new field. I do not want to do this manually. I'm hoping for an update query or script to do this. Any ideas?

Thanks in advance!

-Andrew

 

[PauloRico]

If you create the new field as an Autonumber field, Access will do this for you.

Hope this helps