Unmatched query question

[Angela]

I have a table containing training records which includes the course number,
employee number and date for the training class. I have an unmatched query
that finds the employees that haven't attended a specific course. My
question - is there a way to find multiple courses that they haven't attended
and then group them by course number?

I am using two queries for the above task. The first one finds all the
employees that DID take the course in a specific time frame (fitlers by
course number and dates). The second query lists everyone from the employee
table that doesn't have a matched record in the first query. I then print a
report listing employees that haven't taken the course.

The 2nd query doesn't return the course number since it's looking for
unmatched records. Short of creating multiple unmatched queries and joining
them with a union query, I don't know if there's any way to find multiple
courses. I would like to be able to print a list of employees that haven't
attended certain courses (for example, all the 'required' courses).

Anyone have any ideas?

 

[KARL DEWEY]

Change your method. First query as a Cartesian product by placing the
employee and course list tables in the space above the grid with out joining
them. Have employee and course information in the output. It will produce a
list of all employees and all courses.
Then unmatched query to find the employees that haven't attended a specific
course. Use the first query left joined to Employee-Course table on both
employee and course fields with criteria Is Null.

 

[Angela]

Thank you, Karl. I may need to do a little experimentation to get this to
work since I believe the report is now showing 'those who did not attend a
course on a specific day' versus 'those who did not attend a course on any
date within a certain time period". Am sure I will figure out how to get
this with some grouping.

Had not even thought of Cartesian, so thank you very much for your repsonse!
A much easier solution than what I was attempting.

 

[Angela]

Disregard my comment about the report grouping on date and not just course -
it was a grouping error on my part. It works great, and thank you again for
your help!