Leslie,

One other approach might to be create five queries that generate each piece
of the line

1. One that groups by all of the data as described above.
2. One that reads the temp table and creates a table with the first three
columns.
3. One that reads the temp table and creates a table for the 2nd column set
4. One that reads the temp table and creates a table for the last columns

A fifth would join the last three tables into one, resulting in one line per
employee with all of the data on it.

Dennis