Create an Exception Report

[mamaw]

I have a database that contains several tables relating to training. One table contains associate names, departments, and clock numbers. One table is linked to another database and contains document numbers, titles, revision levels, and effective dates. Another table is used for completion of training records. This table has drop down fields in it that uses Clock Numbers and Document Numbers from the other two tables. In addition, the revision level trained is entered and the date of the completed training. I would like to create a query that shows me who has not been trained yet. I have created a query that shows me when a document has not been trained by all associates, but I can seem to find out who has not been trained unless I do a search on each document. We are talking about 6000 documents and 700 associates and multiple revision levels.

HELP!

 

[aleb]

Lets say you have 3 tables : Science, Students , Classes.
Each of the student is supposed to learn every science.
Classes holds information who studies what.

1. Create query with 2 tables science and students. Do not link them. Select ScienceID and Studentid as output fields of this query.
2. Create new query: Select first query and table classes.
Now link it like this:
SELECT Query1.Scienceid, Query1.Studentid, Classes.FScienceid, Classes.FStudentid
FROM Query1 LEFT JOIN Classes ON (Query1.Scienceid = Classes.Fscienceid) AND (Query1.Studentid = Classes.Fstudentid)
WHERE (((Classes.Fscienceid) Is Null) AND ((Classes.Fstudentid) Is Null));

 

[Mile-O]

One table contains associate names, departments, and clock numbers.

One table is linked to another database and contains document numbers, titles, revision levels, and effective dates.

This says that your database is poorly designed.

 

[mamaw]

Thanks Aleb. With a few modifications, that worked well.

SJ McAbney; I realize that the database is poorly designed, but I am working with a database that was created, managed, and owned by another department in our company. It just happens that the database that I control is linked to their database so that we do not have to re-create the wheel. The database that I control cannot be used by any other department. Certain information can only be viewed by others. Thanks for your input though.