Label each row in a table in sequence

[Tcurtis]

Good morning. I am looking for some VBA that would label each row in a table in sequence from 1 to 10. I am counting the number of times a model number comes up during the year. I have them in order of largest to smallest by top 10. I now need to label each row from 1 thru 10. Autonumber will not work because it starts over from the last highest number. How can I have my table or query number each row after I run an update on the data?

 

[ranman256]

You need 2 tables.....
1. the target table you already have,tTarget.
2. An empty version of the target table, with auto num ready to start at 1, TTarget_MT

create the tTarget_MT:
copy the structure of tTarget, empty the table, then compact the db.

then in the macro to create the data,
step 1, copyObject tTarget_MT to tTarget.
step 2, run append query.

The empty table (MT) will always start at 1 since it never gets written in.