Finding Duplicate Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that contains the following information:
Auto ID, PersonName, EventName, EventDate

PersonName, EventName, and EventDate are not unique.
There are thousands of records.

I would like to find duplicate records that repeat
PersonName and EventName. It does not matter if the date
is the same or not.

Ultimately I wish to delete the one with the most current
date, but I also want to know what is being deleted. A
log would be fine.

I assume this can be done. Can someone help me create
the query to do so?
 
I have a table that contains the following information:
Auto ID, PersonName, EventName, EventDate

PersonName, EventName, and EventDate are not unique.
There are thousands of records.

I would like to find duplicate records that repeat
PersonName and EventName. It does not matter if the date
is the same or not.

Ultimately I wish to delete the one with the most current
date, but I also want to know what is being deleted. A
log would be fine.

I assume this can be done. Can someone help me create
the query to do so?
Click to expand...

The Query Wizard will do so: create a new query and select the Find
Duplicates wizard.
 
Back
Top