Calculated Field that averages another field

[www.ttdown.com]

I have a field named [Hours] in a report that returns the number of
hours a person has worked for a time period. The report returns a
line for each staff person with the staff's name. I'd like to add a
calculated field that would return the average of all the hours that
all staff have worked for the period. Something like Sum of
Hours/Number of Staff. Could anyone tell me how to do this? - Thanks

 

[Duane Hookom]

Add a text box to the REPORT FOOTER
=Avg(Hours)

 

[Marshall Barton]

I have a field named [Hours] in a report that returns the number of
hours a person has worked for a time period. The report returns a
line for each staff person with the staff's name. I'd like to add a
calculated field that would return the average of all the hours that
all staff have worked for the period. Something like Sum of
Hours/Number of Staff. Could anyone tell me how to do this? - Thanks

In the report footer, use a text box with an expression.
From your description, I think you can simply use
=Avg(Hours)