newbie needs help comparing and viewing info from several tables

[Guest]

Hi all,
I am working on a web based interface with Access backend. We are using
this tool to track employee training. I have the following tables currently
setup.
Employees - basic employee data
Classnames - list of available training classes
SkillLevel - number of 1-4 for level of understanding of a class
Managers - list of employee managers
ClassesTaken- Table where I store any classes taken this includes.
ClassTakenID(autonumber),EmployeeID,Classname,SkillLevel

Entering and looking up classes and employees is fine. I need to be able to
create a query that list classes NOT taken. Basicaly the opposite of the
classes taken table. I would like to startout with a list grouped by classes
list any employees that have not taken the class. Eventually I will want to
be able to view by individual classes. Any help would be greatly appreicated.
PS. I am pretty new at Access as well.

flanman

 

[John Vinson]

I need to be able to
create a query that list classes NOT taken

Use the Access Query wizard; create an "Unmatched" query.

If that poses problems post back, it's easy enough to do it without
the wizard.

John W. Vinson[MVP]

 

[Guest]

John,
Thanks for the pointer. I almost have it. I did not know that even
existed. I have created the unmatched query. However. The only class names
that are showing up are classes that no one has ever taken. Basically I get a
list of all ee's each with a list of the 4 classes. All employees have
several other classes they they have not taken but other have.