Dan Waters
dwaters at usinternet.com
Sun Mar 25 14:48:41 CDT 2007
Hi Rocky, Sounded good to me but still no. I tried all the combinations of joins and selecting which PeopleID was not equal to the other, but I always get now rows. Thanks! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Sunday, March 25, 2007 1:13 PM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com