Hi I need help with Autonumber sorting out in order (1 Viewer)

Hi,

I am creating a database for cases. I want to set autonumber into sequence, Let say if there are data numbering 1,2,3,4,5. If I delete no.2, The data will rearrange in oreder from 1,2,3,4. While If I add a new value it would be the no.5.

Instead of data value autonumber 1,2,3,4,5 as I deleted no.2 and add new records. The data has become 1,3,4,5,6.

Thanks,

I will look forward to your reply.

I think the quickest solution (and probably the laziest/least professional) is to:
1.) Remove the Primary Key from your table
2.) Copy and paste the data into an excel file or another blank table
3.) Delete all the data in the original table
4.) Delete the autonumber column from your pasted worksheet
5.) Restore the Primary key to the autonumber
6.) Paste the info back in!