Query on ID

[AccessNut]

My database is designed around an apprenticeship. I have tables that hold class information for each student. I am looking to create a query of all students who have not completed the course ID of 93. Help!

[pbaldy]

Simplest way is probably to create a query of all students who have completed that course, and then run the unmatched query wizard with the table containing all students and that query. I'd probably use a parameter query for the first so you can examine any class.