Renumber serial numbers
I have created a database that auto assigns a serial number each time a new account is entered. I imported records from an older database, and it resulted in a gap in account numbers - they go from 1 - 224, and then start again at 500. Currently there are well over 1000 accounts in the database. I would like to write a script that renumbers all the accounts, starting with 1 and eliminating the gap, but my attempts thus far haven't been successful. Can anyone help me with a script to sequentially renumber the existing auto-entered account numbers?