I tried to filter by not a null termed date and the data doesn't change.
In the example I give above, the employee is actually 'active' still since their last line was eff 04/01/2014 to current.
I would not want to show this person on my report because their most current line is showing them still active.
I only want to pull actual termed employees, which I see their records like this:
Eff 01/01/2014 termed 03/15/2014, Jason Smith
Eff 01/15/2014 termed 04/01/2015, Robert Smith
Those two records above would show and this record would not, since her last line is still currently active;
Eff 01/15/2014 termed 04/15/2014, Jane Smith
Eff 04/16/2014 to current Jane Smith
I could be explaining wrong too, sorry! But appreciate your help!