Courses not yet attended

  • Thread starter Thread starter Saylindara
  • Start date Start date
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")
 
One query can get all the 'mandatory' classes attended (per employee),
right?

Another query can get all the 'mandatory' classes (per employee), right?

Create a third query that looks for records in query#2 not in query#1 -- the
query wizard can help with this "unmatched" query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I've done it! Thank you very much for your help.

Jeff Boyce said:
One query can get all the 'mandatory' classes attended (per employee),
right?

Another query can get all the 'mandatory' classes (per employee), right?

Create a third query that looks for records in query#2 not in query#1 -- the
query wizard can help with this "unmatched" query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Back
Top