Monthly Averages

  • Thread starter Thread starter Nedan Nedzatra
  • Start date Start date
N

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.
 
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)
 
Thanks Dale.

Happy New Year

Nedan

Dale Fye said:
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)
Click to expand...
 
Back
Top