S
Saylindara
I thought in my ignorance this would be fairly straight forward. I have a
query which shows the mandatory courses employees have attended and I have
another query which shows the courses they should have attended. I need to
know which ones they have not yet attended and no matter which way I
manipulate the tables I've got nowhere so any help would be appreciated.
The query which shows what mandatory events employees have attended is made
up of
TblEvents QryMandatory TblEventEmployee TblEmployee
EventID EventName EmployeeID EmployeeID etc.
EventName JobTitleCode EventID
etc. EventID EventDate
StatusCode
Whether or not an Event is mandatory is determined by the JobTitle and the
Status(i.e. Mandatory or otherwise for that job title).
The following query gives the mandatory events per job title:
TblStatusCode TblEventJobTitleStatus TblEvent
EventID EventID
JobTitleCode
StatusCode (queried to "Mandatory")
query which shows the mandatory courses employees have attended and I have
another query which shows the courses they should have attended. I need to
know which ones they have not yet attended and no matter which way I
manipulate the tables I've got nowhere so any help would be appreciated.
The query which shows what mandatory events employees have attended is made
up of
TblEvents QryMandatory TblEventEmployee TblEmployee
EventID EventName EmployeeID EmployeeID etc.
EventName JobTitleCode EventID
etc. EventID EventDate
StatusCode
Whether or not an Event is mandatory is determined by the JobTitle and the
Status(i.e. Mandatory or otherwise for that job title).
The following query gives the mandatory events per job title:
TblStatusCode TblEventJobTitleStatus TblEvent
EventID EventID
JobTitleCode
StatusCode (queried to "Mandatory")