Ha - I don't even know what that means.

Allow me to correct my prior post.

Changing the setting to include unique records didn't cause this problem. The problem is caused when I linked a new table and inserted a field that only applies to terminated employees.

The result is that the report now only runs for terminated employees. I want the report to run for all employees but only show the inserted field when displaying a terminated employee.

The original report automatically picked up active & terminated employees and included the following 2 tables:
1. ROTPersonnelStatusTableB
2. ROTPersonnelStatusTable

I added a link to a table called "Closing_Statement"

Then I wrote a custom formula as follows:

If isnull ({Closing_Statement.Vest Cancel Date}) then {ROTPersonnelStatusTableB.Expiration Date}
else {Closing_Statement.Vest Cancel Date}


If instead of using this formula I simply insert {ROTPersonnelStatusTableB.Expiration Date}, the report includes both active and terminated people. However, when I insert the custom formula above, it only pulls terminated people.

I'd like to use my custom formula above and have it show both active & terminated people.

Thanks again for the help.

thanks - how do I change it to an outer join?

Thanks - left outer join didn't fix the problem.

Full outer join seems to have worked.

What do these settings mean?

Right outer join and full outer join work for some people but not others.

For example, all terminated people have a vest cancel date. The report now displays both active & terminated people but it does not show the vest cancel date for all terminated people.

Steve