Correcting data entry errors

[MD]

I import data files from an outside source whom completes the data entry of
freight bills. The issue is incorrect/mulit spelling of the same locations.
How can I correct this before runiing my reports?

 

[Jerry Whittle]

Is there something like a Location ID number that uniquely identifies the
location? If so you could set up a table of Locations with the Location ID
and proper data such as name, address, etc. Then you could join the two
tables on the Location ID to get the correct spellings and such.

If you don't have something like that, you're probably going to have to do
it manually. About the only other thing would be to get the other source to
input data correctly in the first place.