AnsweredAssumed Answered

Renumber serial numbers

Question asked by GaryLewis on Apr 24, 2015
Latest reply on Apr 24, 2015 by philmodjunk


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?