Leslie,

Your example and specification do not match.

You state:

1. One line per employee
4. In addition for the "variable_employees", the query needs to return the
following columns for EACH earlier 'cont rate' value: the 'cont rate' value,
the minimum 'month number', the maximum 'month number', the total of 'nhsp
ees', and the total of 'pen pay'.

James Bond has three "cont rate". However, the report only shows the lowest
and highest "cont rate". It does not show the middle value, which
contradicts your stated requirement number 4.

What's the story on this?


Dennis