Need your Help - Average

  • Thread starter Thread starter learning_codes
  • Start date Start date
L

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
 
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/
 
Back
Top