I have a table that has duplicate numbers in the ID column and I want to get rid of them.
When I first populate the table I need to have duplicate numbers since I run some code that breaks part of the records into two. After I'm done with that I need to change the ID field so they are all different.
Is there a simple way to do this? Or should I create another column that uses autonumber then delete the first column? I would like it if I could run an update query that would change the ID numbers, so it can be automated.
When I first populate the table I need to have duplicate numbers since I run some code that breaks part of the records into two. After I'm done with that I need to change the ID field so they are all different.
Is there a simple way to do this? Or should I create another column that uses autonumber then delete the first column? I would like it if I could run an update query that would change the ID numbers, so it can be automated.