I need to create a report that shows my entire list of Active Staff, and whether or not they have completed a specific training.
My problem is that people who have not completed the training yet, do not have the course entered into their record.
Ideally I’d like to be able to pull a list of all active staff; if they have completed that specific training, the completion date will show. If they have not completed that specific training, the completion date column will just remain blank.
Anything I am attempting is either (A) only pulling the people who have completed the training (since they have that course in their record), or (B) is pulling all active staff, but listing EVERY training course they have in their record.