My boss just got some new data tables.
The problem is they are overlapping data and everything is fine.
UNTIL
ok show me everyone in table 1 that doesn't match anyone in table 2.
WHAT?
so he wants every name in one table that doesn't match someone in the
other table??????????
at first I tried to say if its in table 1 and not in table 2 include
it.
but I can't get it to work.
forget matching I need to find no match in a query.
what am I missing here...should this be easy?
thanks for any ideas
Jerry
> My boss just got some new data tables.
>
[quoted text clipped - 17 lines]
>
> Jerry
Click on Queries + New + "Find Unmatched Query Wizard"

Signature
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
sparks - 30 Jan 2006 19:21 GMT
thanks for your help fredg I had never used one of these before.
simple as pie
Jerry
>Click on Queries + New + "Find Unmatched Query Wizard"