Delete duplicates from a table

[mls via AccessMonster.com]

I want to delete duplicate records by comparing 25 fields( basically check
all the columns) .
I always use distinct to check a single column but not sure how I can check
all the fields!!

 

[John W. Vinson]

I want to delete duplicate records by comparing 25 fields( basically check
all the columns) .
I always use distinct to check a single column but not sure how I can check
all the fields!!

One way to do this is to create a new table with the same fields (copy and
paste the table, selecting design view only); then create an Append query with
its "Unique Values" property set to Yes. The SQL equivalent would be

INSERT INTO newtable
SELECT DISTINCT * FROM oldtable;