Need to develop a simple search tool

B

bobm

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
 
D

Dirk

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.
 
Top