Report on Sums from Combo Box?

[OceanBlue]

I have created a report based on a query. 2 of the fields I have are Total Worked Pages and Job Effort. Job Effort has 3 values: My Work, My Corrections, Others

I need to see the on the report the

sum of Total Worked Pages when Job Effort is My Work
sum of Total Worked Pages when Job Effort is My Corrections
sum of Total Worked Pages when Job Effort is Others

Can someone please assist me.

Thank you

 

[Lilliabeth]

Group by Job Effort and include a group footer. In the Group Footer, put a text box with the following Control SOurce property:

=Sum([Total Worked pages])

 

[OceanBlue]

Thank you Lilliabeth but I would like to group my report Employee Name. I don't really want to have a grouping level for the Job Effort. I would like the totals to appear and the end for each employee. Would that be possible?