hello
After the departure of the previous admin, I've inherited a 2007 database covering 150 staff, across 4 locations. If possible, I want to add another query to it, but not sure if my quest is even possible.
Essentially, the main tables involved are :
lookups forEmployee - lists all employees (Number, FirstName, LastName)
Training
which lists employee, course undertaken and date completed.
I've had a quick look through queries section and cant find anything that covers this scenario,
Queries already exist to create employee history reports which also identify employees needing refresh training.
I am trying to achieve a QBE query that compares employees against the all courses table in an attempt to identify those colleagues who have not undertaken a training course.
hope this makes sense
any ponters gratefully received
Flump
After the departure of the previous admin, I've inherited a 2007 database covering 150 staff, across 4 locations. If possible, I want to add another query to it, but not sure if my quest is even possible.
Essentially, the main tables involved are :
lookups forEmployee - lists all employees (Number, FirstName, LastName)
- All Courses available - ( Courses, CourseLength, ValidityPeriod)
Training
which lists employee, course undertaken and date completed.
I've had a quick look through queries section and cant find anything that covers this scenario,
Queries already exist to create employee history reports which also identify employees needing refresh training.
I am trying to achieve a QBE query that compares employees against the all courses table in an attempt to identify those colleagues who have not undertaken a training course.
hope this makes sense
any ponters gratefully received
Flump
Last edited: