I think I've run into a bit of a problem with a report I'm finishing up.  It is a rather complicated report but what it does is basically calculate the direct and indirect hours that employees log on their "timesheet" program.  I have everything exactly the way I want except I need to summarize the indirect hours in the the footer.  So basically I want to do this:

List the most common Indirect hour types and calculate the total hours spent on each type.  For instance if there are three types (maintenance, cleanup, meetings) then I would like to list them and how many hours went toward each type.  the report shows the hours logged for each employee, but I am having a heck of a time getting this little analysis section to work.  Any help would be appreciated.  I would even be willing to email the .rpt file, because you may need to look at it to see exactly what I am doing.

I think you might be onto something there.  I tried this, but the problem is the actual hours field is not a number.  It is a string.  I don't believe that I can sum that. 

I see what you're saying.  I'm still struggling I'm afraid...

Would you mind if I emailed you a copy of the report.  My fear is there is something very simple that I'm missing here and not explaining properly.