View Full Version : auto fill


rschultz
07-17-2001, 01:43 PM
I know how to create a new numeric field but how can I fill it with numbers from 1 to what ever the highest number is?

JohnnyBoy
07-27-2001, 07:56 AM
use autonumber. This will automatically populate when a record is entered

rschultz
07-27-2001, 10:46 AM
I looked up Createtable and Type Property but I didn't see and Autonumber example. Can it be done on the fly using code?

Fornatian
07-27-2001, 12:47 PM
What objective are you working towards?
The data in a a table is not stored in any particular order therefore to number records without imposing a sort on the table will lead to sporadic results.

If you are seeking to create a unique reference use an autonumber field, it won't always be incremental but it will give a bookmark to indicate record input, again you would need to consider how to sort the data.

An append query would probably be your best bet by importing all the records(via a sorted query) into a new table with an autonumber field.

Ian