Removing duplicates in field

[TheEnigma]

Hello,

I have a whole lot of name and address data in a table that gets imported from an excel spreadsheet.

My problem is that there are many duplicate address records in the "add1" field. This field shows the street number and name. This happens because there are often people at the same address with different names.

I need to remove duplicates of records in that query (still leaving one of the records in there) that I have run. So in other words if there are 3 records for 12 Smith Street, I only want 1 record for 12 Smith Street to appear.

Access has a find all duplicates query wizard, but that doesn't help me remove the unnecessary record.

Can anyone help me?

 

[SQLBI]

Hi,

SELECT DISTINCT add1
FROM tblTable;

Will return a dataset free from duplicates.

Hope this helps.

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk

 

[TheEnigma]

Thank you for that!