Average in a Sub Report Not Working

[MichelleM via AccessMonster.com]

I have created a report that has 2 sub reports in it. The report consists of
call handling data for 6 agents. One of the subreports contains a field that
averages the data among the 6 agents. When I run the sub report on its own,
the average field works fine. When I run the main report the average field
only uses the one agent. So if Jane Doe's data was 94%, then her "team
average" is also 94%. When I go to the next agent, John Smith's data was 87%,
and the "team average" listed there is also 87%. It should list the average
of all (e.g. 94+87/2=90.5%).

Thanks for any help!

 

[John Spencer]

It sounds as if the sub report is linked to the agent instead of to the team.

I would check the Link Child Fields and Link Master Fields properties of the
sub-report control and see what the values are there.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Duane Hookom]

Each instance of the subreport will only be able to reference the records in
the instance. If you want a subreport to display an aggregated value from
more records, you may need to:
- create a totals query that calculates the aggregated value
- add the new totals query to the record source of the subreport

 

[KARL DEWEY]

Mathematically you can not do it.
Average 50, 50, & 50 = 50. Average 10, 100, 50, 50, and 75 = 57

Average 50 & 57 = 53.5
Average 50, 50, & 50, 10, 100, 50, 50, and 75 = 54.375

Put agent averages in subreport footer and overall in report footer.