A simple Query...or so I thought!!

  • Thread starter Thread starter Deleted member 73419
  • Start date Start date
D

Deleted member 73419

Guest
Hi,

I have inherited a database with a rather large table (12K+ records) which contains a lot of duplicates.

What I need help with is a query to delete any duplicates having a count > 1 and leaving me with just one copy.

The database looks like this:

Code:
ID          Group          Title
==          ====            ====
1           000            Blood
2           001            Sweat
3           002            and Tears
4           000            Blood
5           001            Sweat
6           002            and Tears

Any help is appreciated

Thanks
 
Do a Group By on the Group and Title fields with a Min on the ID field.
Delete any records by ID not included in this result.

Incidentally 12K records isn't large.
I have a table with 4.6 million records and no sign of Access choking on it yet.
 
Do a Group By on the Group and Title fields with a Min on the ID field.
Delete any records by ID not included in this result.

Incidentally 12K records isn't large.
I have a table with 4.6 million records and no sign of Access choking on it yet.

4.6 million records :eek: Ok i'll re-phrase that...not the amount of records i'd like to go through manually!!

I'll give your suggestion a go and see how I get on :)

Thanks
 
4.6 million records :eek: Ok i'll re-phrase that...not the amount of records i'd like to go through manually!!

I'll give your suggestion a go and see how I get on :)

Thanks

Do you want to delete duplicate record or duplicate field. Duplicate record means all fields have the same value. Deleting dupicate field use group by option. Deleting duplicate records visit learnmsaccess.weebly.com. You will find the answer
 
I gathered the goal was to delete records that duplicate information in the Group and Title fields but have different IDs. ID is generally a primary key so there would be no duplicate records in the precise sense of the word.
 

Users who are viewing this thread

Back
Top Bottom