jonathanchye
Registered User.
- Local time
- Today, 08:26
- Joined
- Mar 8, 2011
- Messages
- 448
Basically I have to data cleanse a field of Company names from a table. I currently have 2 tables. Table 1 contains the field I want to data cleanse. Table 2 contains the list of proper Company names.
So for example in Table 1 I have variations like aCme company, ACME LTD, ame limited, ACME, Acmelimited. In Table 2 I have the proper name which is "Acme Limited".
Is there an easy way to create a custom query to search through Table 1 and change it to the proper name in Table 2?
Current I have an Update Query to search for names in Table 1 using "Like *". This works for one company but I have over 100s of company names in the list and it would be too tedious to construct 100 queries to do this task(!).
I tried to fit multiple names in one query but I have an error saying "Duplicate destination field).
Hopefully someone could advise.
So for example in Table 1 I have variations like aCme company, ACME LTD, ame limited, ACME, Acmelimited. In Table 2 I have the proper name which is "Acme Limited".
Is there an easy way to create a custom query to search through Table 1 and change it to the proper name in Table 2?
Current I have an Update Query to search for names in Table 1 using "Like *". This works for one company but I have over 100s of company names in the list and it would be too tedious to construct 100 queries to do this task(!).
I tried to fit multiple names in one query but I have an error saying "Duplicate destination field).
Hopefully someone could advise.