Skip to Content
0
Former Member
Oct 24, 2006 at 12:59 PM

problem with query

24 Views

Hello Gurus,

I have problem with query,...this is simle example what I need to do actually,...

that is my data:

Amount = firs column, Sum = second coulmn, Average=third coulmn

AAA 1 5 5

BBB 2 12 6

<u>CCC 3 21 7</u>

Sum 6 38 18(6.33)

I need to do couting (for example) after first three rows. The result is in first column 6, what is true,....123=6,....in second column that is 38, what is true also, because 51221=38 but in third column is result false!!!!!!!!! 5 + 6 + 7 = 18, but average is not 18!!!! Average is 38/6!!!! this is what I need to get, I need to buid query with subtotal 38/6=6,33.

18 is just sum of column(Average),...but I need to get "avegage of averages"!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Could you please send to me any suggestions? What should I do???

Thanks.