Filtering Queries

[solo7]

I have 2 queries both of which return correct results. First query lists all students, second query list students who are in a specific class. How can I merge these two queries so that query 3 displays all students who are not assigned to the specific class?
Of course if there is a one query way I'm all ears ...

solo7

 

[M8KWR]

you easiest way would be to use the query wizard and select "Find unmatched query".

The first table you would select would be Query 1 then select Query2, and link the field of Student name etc.

And that should display what you need.

Hope this helps.

 

[mp9]

One-query approach:

SELECT tblStudent.StudentID
FROM tblStudent LEFT JOIN tblCourse ON tblStudent.StudentID = tblCourse.StudentID
WHERE tblCourse.StudentID Is Null

Hope this helps.

http://www22.brinkster.com/accessory/