Two rows for one employee

Summary

Two rows for one employee

Content

I have a report that I run that lists all active employees, plus the employees that were terminated in the last 45 days. We had a situation where an employee terminates but comes back to work in 30 days, so he has two rows - one term and one active. Is there a way to show only his current active record and not the termination record on my analysis?

Thanks in advance,

Allie