Report/Code Logic

A

AnnMarie

I need a report to list Mandatory Courses and the Employees who haven’t
completed them.

The table relationships are set up as: tblCourse à tblClass à
tblRegistration ß tblEmployee

I have a query – qryMandComplete – that links all the tables & lists
Employee, Class & Registration info for those who completed a Mandatory
Course (a Course is specified as Mandatory in tblCourse).

I tried creating an unmatched query comparing tblEmployee to
qryMandComplete, but I’m not able to determine which Course they didn’t
complete. I was thinking I need to cycle through a recordset of tblEmployee
and if the Employee exists in qryMandComplete…move to the next tblEmployee
record. If a match isn’t found…print it out. But again, I’m not sure how to
tie in the Course. Perhaps a loop to specify the course for each cycle?

My output should list each Mandatory Course and the Employees who haven’t
completed them:

MandatoryClass1
Doe, John
Smith, Bill

MandatoryClass2
Doe, Jane
Doe, John
Smith, Bill

Can anyone offer me some guidance? Am I making this more difficult than it
needs to be?
 

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

Similar Threads

Expression Builder; embedded data from other reports in Summary re 4
Using DCount in report with parameter qry 1
File disconnect with QueryTable 1
remove all duplicates? 3
very slow report with dcount() 6
Combine rows of data and use if/then with results 6
Crosstab Report 1
Button macro to move/delete active row 4

Top