Grand Average of Averages within Grouped Section

[Guest_imported]

I have a report which displays individual values grouped by date. The date footer averages the individuals scores for each date using the AVG function. For the report footer, I want to add Grand Averages which average based on the Date footer averages, not by the individual scores. How can I achieve this? Thanks in advance - John

 

[JerryDennison]

Why would you want an average of the averages? Why not just an overall average of the entire data set? Anyway, you'll have to do a little slight of hand to get this. Create two hidden unbound controls on the date footer. One, we'll call intCount. Set intCount's controlsource property to =1 and it's running sum property to yes. The other one we'll call txtDateTotal. Set it's controlsource property to the same formula you have for the date footer's sum control. Set this control's running sum property to yes also. Hide both controls by setting their visible property to no. In the Report Footer add an unbound control with the following as it's controlsource:
=[txtDateTotal]/[intCount]

This should give you what you're looking for.

 

[Guest_imported]

Thanks - it worked!
The reason that I wanted averages of averages is that I'm interested in displaying the dynamics of a higher unit of analysis, irrespective of the varying number of valid scores within that higher unit of analysis. So, instead of averaging across every individual score, I want to average the summary of those individuals in terms of their grouped averages over time. Thanks again for your help - John

marcuse1835@hotmail.com

 

[JerryDennison]

You're welcome.