Create new Random 6 digit field for each record.
Posted on 2003-11-26
I have a table which holds clients; currently i have the autonumber field generating unique numbers, however, with the constant deleting of records this isn't working as it continues to "increment" and skips many available numbers. So I would like to assign new random numbers (6 digits) to each one and then I will rename that field to the new ClientID ... but I am having a hard time setting up a recordset. For some reason, I can't figure out how to say, "Open the clients table and then go thru each record assigning a random 6 digit number to the NEWID field" .... hmmmm