Grand Total

[Quicksilver2002]

I have a report that adds total training hours for every employee. I split hours and minutes up into two textboxes because some training will be over 23:59. My totals are in the Code Footer. Here is my code for those:

TotalHours:
=Int(((([Hours1]+IIf([TrainingOperPro subreport1].Report.HasData,[TrainingOperPro subreport1].Report!Hours2,0))*60)+([Minutes1]+IIf([TrainingOperPro subreport1].Report.HasData,[TrainingOperPro subreport1].Report!Minutes2,0)))/60)

Total Minutes:
=Int(((([Hours1]+IIf([TrainingOperPro subreport1].Report.HasData,[TrainingOperPro subreport1].Report!Hours2,0))*60)+([Minutes1]+IIf([TrainingOperPro subreport1].Report.HasData,[TrainingOperPro subreport1].Report!Minutes2,0))) Mod 60)

I need a Grand total in the Report footer to add up the totals. I can't seem to get it to work.I've tried a few things and all i can seem to get is the Last Employee's

 

[ashley0578]

Have you tried a crosstab query that would add up all the hours for you for each individual?

 

[Quicksilver2002]

I have it adding up totals for each employee. I just can't get a grand total. Anything i Put in the Report footer. I get a Enter Parameter Error.