So... I've created a basic payroll DB and am using a crosstab query to show employees pay by department. The report initially showed lots of rows of hours per employee but all I wanted was the total per employee per department so I left the sum on the report and ditched the detail.

eg. =Sum([Cleaning])

This all looks great and work EXCEPT now I need the total pay for each employee, ie the total of all of the sums of all of the departments.

Can it be done?