[AccessD] NOT Query.

I knew that would come up just as soon as I sent the e-mail.  Maybe Drew is
sleeping today and won't see this?!?!?!

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, March 31, 2009 9:10 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] NOT Query.

If you're sure Clients is actually null... what happens if they're just
empty?

<groan> :)

Susan H.


> How about another query with a left join from query B to query A, and pull
> only the records where    queryA.Clients is Null, ie:
>
> SELECT QueryB.Clients, QueryA.Clients
> FROM QueryB LEFT JOIN QueryA ON QueryB.Clients = QueryA.Clients WHERE 
> (((QueryA.Clients) Is Null));
>
> HTH
>
> Rusty
>

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************