I have a list of dates corresponding to department transfers and
terminations.  The list for a given employee may look something like
this:

1/1 - Dept A
2/1 - Dept B
3/1 - Quit
4/1 - Debt A
5/1 - Dept C
6/1 - Term'd

I need to have a query that will pick out 1/1 and 4/1, as those would
be hire dates.  For tables I have tbl_employee_info, tbl_term_history,
and tbl_dept_history.  At this point, I've got the EmployeeID, term
dates, and the very first date like this:

1   3/1   1/1
1   6/1   1/1

What I need is:

1   3/1   1/1
1   6/1   4/1

Does anyone have any idea how I'd go about this?  Hope all of this
makes sense.

-Josh Nikle