Need your Help - Average

[learning_codes]

Hi,

I'm able to create average in Part A, B, C, D but couldn't do average
in All Parts in a same query.

Avg
Part A - 25
Part B - 30
Part C - 20
Part D - 35
All Parts - 32 (including Part B, C, D but excluding Part A)


Your help would be much appreciated.

Thanks

 

[Jeff Boyce]

If you are attempting to take the average of averages, be aware that this is
NOT mathematically sound.

If Part A's average of 25 was based on a sample of 10,000 items, while Part
B's average of 30 was based on a sample of 2 items, the overall average is
going to be much closer to 25!

To get an overall average, add up all the values and divide by the number of
values.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/