Simple Report

[ptrifile]

I am trying to create a simple report with 2 tables. tblEmpInfo and tblsurvey. They are joined with employeename. If the persons name is in tblEmpInfo and not tblsurvey the person is not shown. I would like to be able to show all employee names with a 0 (zero) next to the names that do not have an entry in tblsurvey.

This seems very simple to me but I just cannot seem to get it to work. Any suggestions?

Thanks in advance

Paul

 

[briangriffin]

In the Database Expert, double click on the join and then select Left Outer (making sure that tblEmpInfo is on the left side in the table diagram).

That will give you one or more records for every employee, regardless of whether or not they have a record in the survey table.

Employees that don't have a survey will have a null value - if you want to display a 0 then you'll need to write a simple formula, post back if you get to that point.