Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Report to show students that have not taken a class

Discussion in 'Information Technology' started by jackie, Jul 28, 2006.

  1. jackie

    jackie
    Expand Collapse
    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
     
  2. Loading...

    Similar Threads Forum Date
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    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.

    --
    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" <jackie@discussions.microsoft.com> 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
     
  4. jackie

    jackie
    Expand Collapse
    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

    "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
    > 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" <jackie@discussions.microsoft.com> 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

    >
    >
    >
     

Share This Page