Remove duplicate records without using append query and make a table

[Ghoztrider]

I would like to remove all duplicate records from a table I have setup. I have created a find duplicates query using the wizard which works great. What would I put in for a statement to add to the query that would delete the duplicates. It doesn't matter which record gets deleted as long as there's no duplicate. Here is my setup:

My table name is "BCES" and the field I will be using to remove duplicates from is called "BC"

Thanks!

 

[apr pillai]

If you have duplicate records with the same values in all fields of 2 or more records then create a Maketable Query and create an output Table after suppressing duplicates with the following SQL:

SELECT DISTINCT Table1.* INTO Table2
FROM Table1;

This will create the output file Table2; after removing duplicates. Rename Table2 as Table1 after deleting old Table1 with duplicate records.

 

[Ghoztrider]

This is exactly what I don't want to do. I would like to supress the records without having to manage the tables. Call me lazy, but there has got to be a way to do it without creating extra tables. I am a minimalist at heart. If the code you presented me is the only way to do it, then I'll use it. Thanks for the reply.