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