I have a database in which there are company names each matched with the company post code. However there are duplicates since the company names are written multiple ways, like this:
Company Name Zip Code Sabuncu Ltd 55200 Sabuncu L.t.d. 55200
I would like to get rid of duplicates and have only one company name with a matching zipcode. I am using MS Access 2003.
I can provide more details if needed.