Chris,

Thank you so much - it works except for the rounding.

I tested it with different hours and in some cases the total salary for the employee ends up being 2000.01 or 2000.02 etc.

In my example, the total each employee was 2000 but the live database of course will have different amounts.

Essentially it is a valid assumption to make that the total of the Sum(Amount) Column for each employee where the Hoursworked are greater than 0 is their Gross Salary.

Any additional assistance will be highly appreciated.

Thanks