Delete Duplicates

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

Guest

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
 
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

append query and duplicates 2
calculated field 2
Select Top Query 2
Mapping strings to integers 5
Awkward query! 1
remove duplicate records in Access 2007 7
Deleting duplicate records 3
Query for Day of week 1

Back
Top