Monthly Averages

[Nedan Nedzatra]

Hia!

How are you friends!!

Some help please;

I have a 2 column table on Access 2002. One field(ProductsSold) has inetgers
and the other dates spread over 2009(DateOfSale); 100000 transactions. I want
monthly average product sold per transaction as a query result. The query
result will have 2 fields with 12 records.

Have a great New Year Friends.

 

[Dale Fye]

Nedan,

Assuming that each record in this table is a transaction then you should be
able to do:

Select Month(DateOfSale) as MonthOfSale,
Avg(ProductsSold) as AvgProdPerTrans
FROM yourTable
WHERE Year(DateOfSale) = 2009
GROUP BY Month(DateOfSale)

 

[Nedan Nedzatra]

Thanks Dale.

Happy New Year

Nedan

Nedan,

Assuming that each record in this table is a transaction then you should be
able to do:

Select Month(DateOfSale) as MonthOfSale,
Avg(ProductsSold) as AvgProdPerTrans
FROM yourTable
WHERE Year(DateOfSale) = 2009
GROUP BY Month(DateOfSale)