[AccessD] NOT Query.

Try the Unmatched query wizard.  In the query container click New, then Find
Unmatched Query Wizard (creates a query the finds record in one table that
have no related records in another table)? 



Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Sunday, March 29, 2009 8:12 PM
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