dwain.c is correct that once you have a Rep table, you should really capture the HireDate and TerminationDate.

Then all you need to do is correct the Rep table WHERE clause to look at TerminationDate.

Glad it's working.