Autonumeric Fields And Data Order In a Table

[ricardo1023]

I do have a large collection of data in a table. I do want to create an autonumeric field to keep the order of the table when exporting (by sorting by that field on the query). The problem is that after creating the autonumeric field (using increment) Access generates the numbers on the new column (the autonumeric one) out of order! What do determine in which order the autonumeric values are generated (I was expecting to have the values 1,2,3.... in the same order as the data on the table is).

Thank you

 

[2Grandpa]

Try creating a blank table with all the fields including the autonumber field and appending the data to the table?