[AccessD] In this Query but NOT that Query

Dan Waters dwaters at usinternet.com
Sun Mar 25 12:38:59 CDT 2007


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





More information about the AccessD mailing list