Report to show students that have not taken a class

[Guest]

Is there a way to create a report or query showing students who have not
taken a class. The db has a relationship between students and classes. You
add sutdent's names to a subform in the class form. How would I show the
students who have not taken a particular class

 

[Allen Browne]

If this is just a matter of listing all students who have not enrolled in
the class, you could create a query that lists those who have taken then
class. Then use this query as an input "table" for the Unmatched Query
wizard (one of the choices when you create a query.

Chances are, there's much more to it than that, though, because not every
student needs to take every class. For example, an engineering student
generally doesn't have to take "Shaksperian Literature". So you would need a
data structure that identifies the compulsory and optional units that make
up each course, identify the units the student has already taken, then then
match these 2 queries against each other to find the compulsory units that
are lacking and the optional units that could be taken, possibly eliminating
the optional units that have prerequisites the student has not done yet.

 

[Guest]

Thanks Allen! The unmatched query was just what I needed. I knew it was there
but I had never used it. I thought I needed to do some kind of SQL statement.
You got my boss off my back.

Jackie