I
insp36rls
I am creating a database to track employee training. I have created 3 tables:
my first table is for general employee information, my second is for employee
training history which is linked to the first table by the employee #. This
table list all of the classes that the employee has taken to include course
name, course#, class #, date completed and date re-current training is due.
My third table is linked to the second table by the course name and contains
all of the courses available for the employee to take. Some of these classes
are mandatory classes and I have used a yes no field to identify them.
I need to build a query to identify all of the employees who have not had
any or all of the mandatory classes. This is starting to get the best of me.
Is there a way to do this or am I beating my head against the wall?
Your help with this would be greatly appreciated
insp36rls
my first table is for general employee information, my second is for employee
training history which is linked to the first table by the employee #. This
table list all of the classes that the employee has taken to include course
name, course#, class #, date completed and date re-current training is due.
My third table is linked to the second table by the course name and contains
all of the courses available for the employee to take. Some of these classes
are mandatory classes and I have used a yes no field to identify them.
I need to build a query to identify all of the employees who have not had
any or all of the mandatory classes. This is starting to get the best of me.
Is there a way to do this or am I beating my head against the wall?
Your help with this would be greatly appreciated
insp36rls