Negative selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to produce a query so simple, I'm almost embarrassed to ask this
question! I have two tables: (i) Projects, which lists a number of projects
for student assignments, and (ii) Students, which lists the students and the
projects they're to conduct. Students are divided into groups of five, and
each group is to conduct a single project. No two groups will conduct the
same project. I can easily generate a query that returns the unique
ProjectIDs for projects selected by student groups. However, I cannot
generate a successful query that returns a list of projects that have NOT
been selected; i.e., what projects are left over after every group has
selected a project? Can anyone help?
 
Gregp said:
I am trying to produce a query so simple, I'm almost embarrassed to ask this
question! I have two tables: (i) Projects, which lists a number of projects
for student assignments, and (ii) Students, which lists the students and the
projects they're to conduct. Students are divided into groups of five, and
each group is to conduct a single project. No two groups will conduct the
same project. I can easily generate a query that returns the unique
ProjectIDs for projects selected by student groups. However, I cannot
generate a successful query that returns a list of projects that have NOT
been selected; i.e., what projects are left over after every group has
selected a project?
Click to expand...


Try using the Find Unmatched Query Wizard
 
Back
Top