crosmill
Registered User.
- Local time
- Today, 14:29
- Joined
- Sep 20, 2001
- Messages
- 285
I have two tables, where the data should be the same, however, both tables have been inputted independently of each other.
I need a way to compare the data in each table that will allow for these discrepencies.
eg. Company Name
Table 1
British Telecomunications
using "British *" will return from Table 2
British Telecomunications
British Telecom
British Gas
British everything
I want it to be able to recognise the similarities. I know it's a lot to ask form Access, but I'm hoping someone will be able to help.
I need a way to compare the data in each table that will allow for these discrepencies.
eg. Company Name
Table 1
British Telecomunications
using "British *" will return from Table 2
British Telecomunications
British Telecom
British Gas
British everything
I want it to be able to recognise the similarities. I know it's a lot to ask form Access, but I'm hoping someone will be able to help.