Delete Duplicate Records

[andysgirl8800]

Help please!
I have a form (frmHalfTab) built on a table (tblHalfTab2) that has existing data in it. In the very near future, I will be uploading additional data to this table via excel cut and paste. What I want to do is search for and eliminate duplicate records that have duplicate data in TWO fields, (MemberNum) and (MBRDrug), so that if MemberNum is "10" and MBRDrug is "Zzz" for more than one record, the duplicated records need to be deleted, OR a check box needs to be checked automatically for all the identical records, the original and the duplicate(s). I wanted to put this behind a button, if possible.

Now, I have created a duplicate query that will find the duplicated records, but I'm not sure how to use it to get rid of the duplicated records or check the checkbox appropriately. Should I ditch this query and choose a different route, or am I on the right track? Thanks in advance for your help.

 

[alastair69]

If you click on the query tab and then "New" there you will see an option to look for duplicates.

Have a play and will will be clear

 

[andysgirl8800]

Thank you for replying-
I've already created this query....I'm just not sure how to implement it....how do I use it to DELETE the duplicates that it finds?