Spellings corrections

[vasu1211]

customer spellings in my table are messed up- the table has two million records and customers are spelt like this

reprographics- this is the correct one
reprog
regrographic
rerprographic
reprographics

there are many like these
now when i summarize some data based on these spellings, all calculations are messed up.

How to correct these spellings in quickest and most efficient way - either through a query or table properties.

 

[Remou]

Have you got a table of correct customers? If so, it may be possible to correct a good many records because they partly match a customer, for example:

[Code with acknowledgement to PHV]SELECT T.CusName
FROM [BadTable] AS T
INNER JOIN [GoodTable] AS P ON Left(P.CusName,Len(T.CusName))=T.CusName[/code]

After that, it may be possible to do something with soundex.

 

[Pacestick501]

Assuming
1) you don't have too many customers that start with "reprog"
2)you're using something similar to MS Access

You could simply filter by selection on reprog and simply do a find and replace.

Having done this turn the "limit to list" property ON and link the field/list/combo box to stop it happening again.