Careat report with using data of each employee from 2 tables

[Guest]

I want to create report for employes courses . So it display the courses that
employee pass them and the courses that employee not yet pass them. the
courses that passed is in table and the courses that not yet assed is in
another table. the report will be grouping by employee number.
Please help me to do it.
Tks

 

[Guest]

you must combine the two tables into one table.

employee, courseName, passed

passed will be a logical field (true,false) or could contain "passed"/"not
passed"

After this is done than you report can Group on employee, then passed