View Full Version : Query to select data that isn't in another query


Pangbiro
01-19-2002, 03:53 AM
I have a query (query A) that selects people, now off of that I have taken a few people who are in a different table (in query B).
Now I want to select the other within query A who are not within query B, I think I'm almost there I just need to know what the code is that I need to put into the criteria to get it to do this.

Thx

jwindon
01-19-2002, 05:51 AM
Use the Find UnMatched query wizard to find the records you want.

Pangbiro
01-20-2002, 07:05 AM
I cannot thank you enough, I've have spent weeks trying to figure that part of this database out, and when I did I ran into that problem,
Thaks for your help...

jwindon
01-20-2002, 07:18 AM
You're welcome.

Pangbiro
01-20-2002, 07:30 AM
Cheers for the last insite, but I got a new one, I need an update querry to update a check box to true but only if another check box on a Form is true.
What do I need to put into the Criterea box?

KKilfoil
01-21-2002, 03:38 AM
Assuming you want to do this for all records in a query or table, and not just the current record on a form:

Create a new query in design view and show the appropriate table/query(s) with the two checkboxes. Select 'Query-->Update Query' from the query design menu. Add the two yes/no fields to the grid. In the 'Criteria' box for the appropriate field, add 'True' (without quotes). In the field to be updated, put 'True' in the 'Update To' box.