Query help please

[CaptainBalrog]

Hi there.
I have inherited a crazy old database.
It has a payments table with multiple instances of supplier code and supplier name. I need to build a query that returns a single record for each supplier code and name but in some cases the supplier name is spelled differently so using DISTINCT will still return multiple records for some supplier codes.

I'm not vastly experienced with sql or access so any help on how to do this would be much appreciated.

 

[llkhoutx]

Use brute force to change misspellings. Access can't read minds.

In the future add suppliers via a combo box, addiing new ones via the NotInList event. his will minimize but not eliminate "stupid user" mistakes.