Select and Delete from table of Dups

[Jaykappy]

I have a table with Duplicates determined by 3 fields. There is no other way to get my data into this system....

What I need to do is create a query that will grab the first instance of each duplicate and delete it....

HOW can I do this?

Ex

ID Field 1 FIeld2 FIeld3
1 3445 10/10/2012 Good
2 3445 10/10/2012 Good
3 9889 5/5/2011 Fair
4 9889 5/5/2011 Fair
5 9889 5/5/2011 Fair

What I want left is

ID Field 1 FIeld2 FIeld3
1 3445 10/10/2012 Good
3 9889 5/5/2011 Fair

[Jaykappy]

I have read that I can copy the Structure of the table and then make one field that I dont want duplicated and make that the Primary Key and then copy the records into that table...thus eliminating duplicates.....
But my table is defining the Duplicate records over a couple fields......not 1...can only assign one Primary Key....so that wont work.....can I do something similar but defining 3 or 4 fields to determine the Duplicate records?

[June7]

Try compound primary key. Set multiple fields as primary key.

[Jaykappy]

Thanks....
was just coming back to let you all know I think I figured it out....I created another field and simply concatonated the 3 fields into one.....then used this as a Primary Key...
Thanks