I have have two tables. One table is older then the other. The other table is the most recent table and has approx 66 new records that have no sales engineer assigned to that account.
What I need to do is take those 66 new records and compare them to the older table to see if there are similar names that might match.
For instance, an account may have come in to our system last month as ABC Enterprise, 46 Street, Newark, NJ and then this month as ABC Co, 46 Street, Newark NJ this month. I have linked Name 1 to Name 1 but it only gives me a return of exact and I can do an advanced search as well but I only know how to do that when searching by a specific name.
Is there a way to link the two tables and create a like query to see if those 66 new accounts could already be in the older table assigned to a sales person?
Thank you
Laurie B.