[AccessD] NOT Query.

EXISTS?

http://www.devx.com/dbzone/Article/9570/1954

Susan H.


> Thanks Max - And i was just looking at (NOT IN) and thinking  "oooh, that 
> looks useful" :)  noted!.
>
>
> Darryl,
> Do not use the NOT IN clause if you can avoid it.  It is extremely slow on
> large datasets.  The quickest way was given to me (I think by Jim) some 
> time
> back but I cannot recall it and don't have time to go searching right at
> this moment.
>
> I have two queries.  Query A and Query B both contain a field called 
> Clients
> (Based on the same underlying data).  A and B correctly return a different
> number of records in the client field.  I want to be able to list which
> clients are in query B that are missing in Query A.  Basically I want the
> opposite of joining the two queries based on the clientfield.
>