Summing Twice on a report?

[Spyder1000]

I’ve got a table with the following fields:

Team
Employee
Call Type
Pass
Fail

Currently my report is set up to produce a new page for each team. It then lists each employee and in the detail section it lists the pass/fail and finally sums it in the Employee footer.

My problem is at the end of each page I want to sum up each call type (3) and then sum that.

Any suggestions?

 

[GingerR]

Where is Call Type listed? in the detail section?

Do you want to sum the CallType for each Team? What if a Team goes for more than one page? Then where do you want it?

What kind of data is in CallType? Please give examples.

Do you mean you want to COUNT call type (3) or really SUM it?

What are you summing in the Employee Footer?