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?
|
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 |