M
MES via AccessMonster.com
I am creating an Access database to keep track of our employees's education
requirements. More specifically, our employees are required to take certain
continuing education courses, and there are several courses. I am able to
query to list what an employee has taken using:
SELECT employee, coursenum, date, etc.
FROM course_attendance_table
However, I am unsure of how to query the courses that an employee HASN'T
taken. This would be assuming that all employees are required to take all
courses.
FYI - I have a table 'employee' containing each employee's info, then a
'course_attendance' table containing the employee, course #, and date of
attendence. I also have a 'course' table containing course # and course name.
Can someone help me with this?
Thanks in advance.
requirements. More specifically, our employees are required to take certain
continuing education courses, and there are several courses. I am able to
query to list what an employee has taken using:
SELECT employee, coursenum, date, etc.
FROM course_attendance_table
However, I am unsure of how to query the courses that an employee HASN'T
taken. This would be assuming that all employees are required to take all
courses.
FYI - I have a table 'employee' containing each employee's info, then a
'course_attendance' table containing the employee, course #, and date of
attendence. I also have a 'course' table containing course # and course name.
Can someone help me with this?
Thanks in advance.