[AccessD] NOT Query.

Steve,

This worked great (with a bit to tweaking to suit the real world rather than my simple example).

Many thanks
Cheers
Darryl.

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


Darryl,

SELECT * FROM QueryB LEFT JOIN QueryA ON QueryB.Clients = QueryA.Clients
WHERE QueryA.Clients Is Null

Regards
Steve


--------------------------------------------------
From: "Darryl Collins" <Darryl.Collins at coles.com.au>
Sent: Monday, March 30, 2009 4:12 PM
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
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?
>


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