We have an employee database that the managers want to use to track mandatory and option training. We already have an employee table, and I added two more.
tblEmployee (EmpID,EmpName,EmpProgram,EmpStatus,HireDate) Has the basic employee information
tblCourse (CrsID,CrsName,CrsDescipt,CrsNum,CrsNeed,CrsFirstDue,CrsRenewFreq) Has the basic course information.
tblTraining (trnID,EmpID,CrsID,TrnDueDate,TrnDoneDate) Connects the employee and course data. The due date will vary based on the onboarding date of the employee. The date completion date is needed to show when complete.
The tables are combined in query to run reports.
The problem with this approach is that the query will only show what training was entered in the tblTraining table. In addition to showing that, I want to see what training was suppose to be assigned. I’ve tried different join methods in the query, but I’m not getting the results I wanted. I want to be able to generate a report that shows all the employees and all the courses, and which employees has completed. Eventually, the dream would be to have ‘program profiles’. Any help in getting this started would be appreciated.