average

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

On May 14, 12:52*am, kevcar40 <kevca...@btinternet.comwrote:
>
>
>
>
>>>>>>>>>
2011 / 134.1 = 15
without seeing the query or all the data, it looks like you've 15
months of data- Hide quoted text -
>
- Show quoted text -

On 14 May, 11:33, Roger <lesperan...@natpro.comwrote:
>
>
>
>
>>>>>>>>>>>>
thanks for reply
>
i dont think i am averaging 15 months
>
i have place the query code below
>
TRANSFORM Sum(Quantity_Query.SumOfQuantity) AS SumOfQuantity
SELECT Quantity_Query.years, Avg(Quantity_Query.SumOfQuantity) AS YTD
FROM Quantity_Query
WHERE (((Quantity_Query.years)='2008'))
GROUP BY Quantity_Query.years
PIVOT Quantity_Query.months In
('January','February','March','April','May','June' ,'July','August','Septemb*er','October','November' ,'December');
>
thanks
kevin- Hide quoted text -
>
- Show quoted text -

On May 14, 4:57*am, kevcar40 <kevca...@btinternet.comwrote:
>
>
>
>
>>>>>>>>>>>>>>>>>>>
so if you just run this query
SELECT Quantity_Query.years, Quantity_Query.months,
Quantity_Query.SumOfQuantity FROM Quantity_Query
WHERE (((Quantity_Query.years)='2008'))
>
you get just 2 values, may and april ?
if that's the case the avg should be 2011/2 = 1005- Hide quoted text -
>
- Show quoted text -

On 14 May, 16:11, Roger <lesperan...@natpro.comwrote:
>
>
>
>
>>>>>>>>>>>>>>>>>>>>>>>
i agree
but for some reason when i run the crosstab query *it returns 134.1- Hide quoted text -
>
- Show quoted text -

On May 15, 3:18*am, kevcar40 <kevca...@btinternet.comwrote:
>
>
>
>
>>>>>>>>>>>>>>>>>>>>>>>>>>
and if you don't use a crosstab, just a regular query
SELECT Quantity_Query.years, Avg(Quantity_Query.SumOfQuantity) AS YTD
FROM Quantity_Query
WHERE (((Quantity_Query.years)='2008'))
GROUP BY Quantity_Query.years
>
what do you get ?- Hide quoted text -
>
- Show quoted text -

On 15 May, 11:11, Roger <lesperan...@natpro.comwrote:
>
>
>
>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
hi
i get the same answer *134.1- Hide quoted text -
>
- Show quoted text -