Adrianne -
If each Date Type can have only one entry per person (i.e., someone
can't have two Rehire Dates), you can use a pivot table. Follow the
pivot table wizard and

Drag Pers.No to the left most column (set field settings subtotal to
none)
Drag Name to the column area adjacent to Pers No
Drag Date Type to the top Column area
Drag Date to the data area. This will likely default to a count.
Change it to sum and change the format to date.
Under Table Options, turn off grand totals for rows and columns

This should get you going. As mentioned it only works if there is a
max of one entry per date type. If there is two, then the date shows in
the table will be significantly off...the year would be in another
century.

- John Michl
www.JohnMichl.com