[AccessD] NOT Query.

Thanks Max - And i was just looking at (NOT IN) and thinking  "oooh, that looks useful" :)  noted!.

cheers
Darryl

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Monday, 30 March 2009 6:10 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] NOT Query.

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.

HTH

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: 30 March 2009 04:12
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] NOT Query.

Hi There,

Having a complete brain fade.  (heh, must be suffering from 'Ribbon fatigue'
or trying to imagine NULL).

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.

This should be easy, but I am stuck! :-(

any pointers?

regards
Darryl.

This email and any attachments may contain privileged and confidential
information
and are intended for the named addressee only. If you have received this
e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this
e-mail
has been sent to you in error. It is your responsibility to check this
e-mail and
any attachments for viruses.  No warranty is made that this material is free
from
computer virus or any other defect or error.  Any loss/damage incurred by
using this
material is not the sender's responsibility.  The sender's entire liability
will be
limited to resupplying the material.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.