Update Query to fill empty field with sequencial Numbers

[Terry]

Hi; I have a table with a empty field called BoxID, is there a way to get an
Update Query to fill in this BoxID field with sequencial numbers?
Thanks Terry

 

[madhouse]

Set its type to "autonumber" and populate other fields and access will fill
it with sequential numbers.

Madhouse

 

[John Spencer (MVP)]

Not any way that I can think of without using VBA.

As noted elsewhere, you could use an Autonumber field to do this. It might do
what you want. Just be aware that you have very limited control over the
autonumber field. You can't change its value once assigned; you can "lose"
numbers if someone starts to enter a record and then cancels the record before
actually creating it.

What problem are you trying to solve with having sequential numbers in your field?