Help needed with finding Duplicates in 1 table, then changing 1 field to make them unique again.

[Philip]

Hello All.
I need some help designing a FindDuplicates query.
Never done them before, so in the dark here.
I have;
1 Table with about 6000 records. None of them are duplicates. I need to
keep them all
I keep a unique field, and normally its a KEY field. I had taken the key
off of it for reasons of importing data, and stupidity, and this has lead to
this stuffup. This "Normally Key Field" is called [Cust_ID]. In the
process of my stuffing around, cleaning up the data that I had just
imported, I was updating the Cust_ID field, and changed a stack of them to
Duplicates (just this one field). Bugger. Should not have left the KEY on
(I know). I now need to create a query to go and update every First (or
second) instance of the same Cust_ID.
In short. I need to search for Duplicates of Cust_ID in my table, and
update one of them to make them unique again.
Can someone point me in the right direction with the Query to find the
duplicates? Once I have that, I'm sure I will be able to do the rest
myself.

Thanks.

 

[Dejan]

Use Access Query wizzard and build "Find Duplicates"
query. The query is updateable. When you run it, it will
show all the duplicates, nicely sorted by your key field.
SInce the query is updateable, you can then manually
correct Cust_ID. When you think you are done, run
the "Find duplicates" query again, just to make sure you
have no more duplicates. Then recreate the Primery Key
and that is it.

 

[Philip]

Thanks. Had forgotten it was there.

All fixed and lesson learned.

Thanks for the reminder... Philip.

Use Access Query wizzard and build "Find Duplicates"
query. The query is updateable. When you run it, it will
show all the duplicates, nicely sorted by your key field.
SInce the query is updateable, you can then manually
correct Cust_ID. When you think you are done, run
the "Find duplicates" query again, just to make sure you
have no more duplicates. Then recreate the Primery Key
and that is it.

-----Original Message-----
Hello All.
I need some help designing a FindDuplicates query.
Never done them before, so in the dark here.
I have;
1 Table with about 6000 records. None of them are duplicates. I need to
keep them all
I keep a unique field, and normally its a KEY field. I had taken the key
off of it for reasons of importing data, and stupidity, and this has lead to
this stuffup. This "Normally Key Field" is called [Cust_ID]. In the
process of my stuffing around, cleaning up the data that I had just
imported, I was updating the Cust_ID field, and changed a stack of them to
Duplicates (just this one field). Bugger. Should not have left the KEY on
(I know). I now need to create a query to go and update every First (or
second) instance of the same Cust_ID.
In short. I need to search for Duplicates of Cust_ID in my table, and
update one of them to make them unique again.
Can someone point me in the right direction with the Query to find the
duplicates? Once I have that, I'm sure I will be able to do the rest
myself.

Thanks.


.