Show Totals on Report

[bcooler]

I have an evaluation report I'm creating that shows labor hours as a function of a particular recall. For example, Evaluation 1 has 2 recalls, R-1 and R-2. Let's say each evaluation takes an estimated 1 hour to complete. I'd like to report the total number of hours the evaluation requires (2 in this example) so I can get funding to do the work. Originally, I created the report to show the same hour requirement over and over for each record(multiple listings due to a need to show material needed for a given recall). However, I've moved the hours field into the header area, limiting the hours to one location. Unfortunately, it only shows 1 hour, where the real answer is 2 hours (2 recalls at 1 hour each). I tried to create a sum via the totals query, but had little luck (mostly because I don't know what I'm doing).

How can I ask the report or query to total the needed hours needed?

 

[lameid]

In the report, change the control source of the control (most likely a text box) from

[Field Name]

To

= Sum([Field Name])

If the name of the control is the field name, change it too....

txtField_Name

 

[bcooler]

Thanks for the great input. It works exactly as you said. However, here's maybe a part that I didn't fully explain. The report tries to reflect the number of hours of estimated work, and the material list needed. When combined, I get many replications of the hours (for my example, I get 1 hour for each of the 15 or 20 parts/records needed for the 2 recalls) so that the total parts list is represented. As I write this, I wonder if I need to figure out how to seperately pull in the hours and material so the hours are not duplicated? I've never done this before, but it sounds a little like subreports?

 

[lameid]

A subreport for materials is a way to go and probably the most intuitive.

There is probably a more complex solution using grouping and running sum. The nuances of this method are not clear to me to tell you exactly what to do. For learning purposes I would stick to the sub report as it is the more direct method.

 

[bcooler]

Yes, this worked great. Thanks for the help!