Need to develop a simple search tool

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

With my job, I need to compare a client list with a third-party list and if
any matches, names returned into a third table. I have Access 2002.

For example client list record 1 is compared against all records in third
party list, then client list record 2 all the way to the last client list
record.

Without reinventing the wheel was hoping someone could point me in the right
direction on this...

Regards, bobm
 
This would very much depend upon what field(s) need to match to make it a
full match. Sounds like this can basically be done with a query somehat like:

Select t1.firstname, t1.lastname From t1 Left Join t2 On t1.firstname =
t2.firstname And t1.lastname = t2.lastname Where t2.firstname Not Is Null
Into t3

Hope that helps a bit.
 
Back
Top