Delete Duplicates

T

TJ

I have a table with the fields member, month, dues. The dues for December
got appended as November so now I have duplicates for the month of November.
I need to delete the duplicate November records. How do I accomplish this?

TIA,

Terry
 
L

Lynn Trapp

Are those three fields the only ones in your table? Is there anything that
would identify the wrongly entered records from the correct November
records?
 
T

TJ

Those are the only fields. I am only trying to delete the duplicate records
which will fix 97% of my problem and I will manually take care of the rest.
I can run the duplicate query wizard and get the duplicates, but how do I
delete duplicate records and leave the others?

Terry
 
Top