Unfortunately the Concatenation will not help me match the present tables.
At this point there are no "unique" keys. The only information I can match
with are the company names. I need some type of universal function that can
match the names of companies on table 1 to those on table 2, maybe some type
of "Like" function. As I described earlier, table 1 has over 900 records and
only 100 had exact matches records in table 2. I need to find a wild card
that can match the other 800. Since there are 800 unmatched names in table 1
it wouldn't be productive to add each one seperately into a query to match
one of the 90,000 in Table 2.
In the long run I am looking for a query that will return all of the records
of Table 1 with updates from table 2 including the policy numbers. If the
wild card could attach or identify the "company" column of Table 1 to the
same column of Table 2 and update the information from Table 2 to 1 (but not
update Table 1 with empty cells from Table 2) that would be a success.
PLease let me know if you have any solutions...my director is getting
impatient!