UNION and Unique ID

L

Liz Steffen

I have duplicate records in my database that I would like to keep and assign
a new unique ID to. Do I need to reassign all records to have new ID's? Do
you have sample code?
 
R

Rob Oldfield

Just appending them to a table with an autonumber pk included would be one
way. The other would be to use some code (I think that would be easier than
using pure queries) to check for duplicates and assign slightly modified
(i.e. ID+"A", ID+"B") ID values.
 
Top