I have company names in 2 tables to compare, but the data is slightly different but same companies. I want to know what companies are in one table but not in another. Here's an example:
Company Name in Table 1 = Virtual Micro
Company Name in Table 2 = Virtual Micro Technologies
Same company, but the spreadsheet I imported for Table 2 had the full name for the company, so therefore they are not compared the same and the query result shows them to be different.
Do they have to be exactly the same, or can I compare a certain number of characters or somehow use the "like" criteria filter?
Jen
Company Name in Table 1 = Virtual Micro
Company Name in Table 2 = Virtual Micro Technologies
Same company, but the spreadsheet I imported for Table 2 had the full name for the company, so therefore they are not compared the same and the query result shows them to be different.
Do they have to be exactly the same, or can I compare a certain number of characters or somehow use the "like" criteria filter?
Jen