Query showing name field when "Total" field is zero

[Gabriel2012]

Hello, we currently run a report that shows a total for "Call Evaluations" for each CSR based on a monthly basis. The call evaluations are entered into "tblCallEvaluation" and this is linked to "TblEmployee". The issue arises when there are no calls scored for a CSR in a period, as their name will only show in the query after there has been an entry under their ID for that period.

I need the names to show, even if the "Score" column is empty so that we know which CSRS have not had any scored. The join is setup to show "All entried from "tblEmployee" and only those from "tblCAllEvaluation" that have matching data, however it is not working.

See picture for more details, thanks.

[June7]

What is the join type set between tblEmployee and tblSupervisor? Looks like INNER. Could there be supervisor records not associated with an employee?

[Gabriel2012]

Hi June, yes there could be supervisors listed without an employee. Currently it is an "Inner join", however I have also tried an "Outer join" to no avail.

[June7]

Seems should work. If you want to provide db for analysis follow instructions at bottom of my post.

Advise no spaces or special characters/punctuation (underscore is exception) in names. Better would be IsPass or Passed.