Courses not yet attended

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")
 
J

Jeff Boyce

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
 
S

Saylindara

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top