hi
I have a query that calculates the average for the year
i group the data by month
i have 2 values for April and may
April = 1908
May = 103
sum = 2011
if i use the avg function it returns 134.1
however if i divide by 12 it returns 167.6
when i check the answer i get 167.6
YTD: SumOfQuantity
in the totals :avg
why does access return 134.1
thanks
kevin
