ms access - Deleting duplicate records using SQL code, searching 3 columns, but showing all columns -

ms access - Deleting duplicate records using SQL code, searching 3 columns, but showing all columns -

i have database trying delete duplicate records (there no way stop these excel spread sheet has on 70,000 records)

i have created couple of queries using sql total number around 1400 records, there still duplicates client has entered postcode instance , 1 time again without space inbetween.

what hoping for, sql query delete duplicate records searching on first name, surname , postcode, need show results columns (title, first name, surname, address, address2, town/city, county, postcode)

i hope makes sense have been searching everywhere answer, nil makes sense first time have started using sql coding finish novice when comes this.

i using microsoft access 2010

in ms access, there wizards, example, find duplicates wizard.

the sql steps below is:

select table1.[atext], table1.[adate], table1.[anumber] table1 (((table1.[atext]) in (select [atext] [table1] tmp grouping [atext] having count(*)>1 ))) order table1.[atext];

if stuck, query wizards helpful.

select query type

select table

select field or fields want find duplicates

select additional fields

the query in design view

ms-access ms-access-2010