Report to show students that have not taken a class

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13514-report-show-students-have-not-taken.html
add sutdent's names to a subform in the class form. How would I show the
students who have not taken a particular class

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13514
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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13514

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jackie" wrote in message
news:EC84DAA5-BA4B-411F-B596-02C3B3244443@microsoft.com...
> 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

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13514

"Allen Browne" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13514
> 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.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "jackie" wrote in message
> news:EC84DAA5-BA4B-411F-B596-02C3B3244443@microsoft.com...
> > 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
>
>
>