finding variables in a query

[roach]

Hello,

I have about 6 names that I am querying for.

How can I set the code or query up that if one or more of the

names is missing it will execute another query on another table

to find the names that were missing?

Thanks for any help/tips!!!!!

-r