How to build a query to show multiple NOT CHECKED fields on table.

[Sharp2112]

Working to try and create a query that shows all employees that have not completed one or more trainings, regardless of how many, as well as show which training they haven't completed (not checked). If they have completed all training than their name would not populate in the results. I cant figure out how to get this down. Thanks for the help!

[ranman256]

Your table is designed wrong.
each training should be a record in a sub table:

EmpID, training, Date.
123, CPR,8/1/19
123, Harassment,null
222, safety, 6/1/19

this way no table redesign is needed for new training,
All classes can be searched in a query.

[Sharp2112]

Your the best. Ill get that done. Thanks

[Sharp2112]

How do I write the query now to show NAME, and All Training Not Completed? When I try to add all of them it makes it so it will only populate employees that have not completed all three.

[Sharp2112]

Your table is designed wrong.
each training should be a record in a sub table:

EmpID, training, Date.
123, CPR,8/1/19
123, Harassment,null
222, safety, 6/1/19

this way no table redesign is needed for new training,
All classes can be searched in a query.

**** Table altered/created. How do I write the query now to show NAME, and All Training Not Completed? When I try to add all of them it makes it so it will only populate employees that have not completed all three.