[AccessD] In this Query but NOT that Query

A guess:

Add qryA and qryB to s new query.  Put PeopleIDfromqryA and PeopleIDfromqryB
in the QBE.  

Link qryA to qryB: all records from qryA and only those in qryB which are
equal.  

In criteria for PeopleIDfromA:  <> PeopleIDfromB to suppress records in qryA
that are in qryB

Maybe.

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Sunday, March 25, 2007 10:39 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] In this Query but NOT that Query

Queries!  They hurt my hair!


I have a qryA which has one field PeopleID.  It has 8 Distinct rows.

I also have qryB which has one field PeopleID.  It has 13 Distinct rows.  In
qry B there are 5 rows where PeopleID is the same as in qryA.

I need to write a query (or queries) which gives me a list of the three
records that are in qryA but not in qryB.  

Any suggestions?

Thanks!
Dan


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

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.17/732 - Release Date: 3/24/2007
4:36 PM