Two tables, all records from one, plus anything in table two 1

[Evelyn]

Employee training DB. I want to draw all employees from Empee Table and list them whether or not they have training listed in the Training Table. What I am getting is only those employees who have done training.

I want a list of all employees so I can tell which ones did not complete the training.

Any help would be appreciated. Thanks.

 

[MajP]

In the query builder right click on the arrow joining the two tables. You should get a choice "join properties". Pick that and you will have choices on how to join your tables.