Query to Sum Values from the Same Month in Different Years

[barkarlo]

How can I make a query where will be comparison sales of products between (only) january 2006 and january 2007.
I have one table with following data:

salesdate   products   quantity    price
01/01/2006   apples     100           20
05/01/2006   pears        50            15
07/01/21007  apples      35            20

for an example.I would like to see how much sold apples in january 2006 and how much in january 2007

[nico5038]

try:
SELECT salesdate, products, Year(salesdate) & right('00' & Month(salesdate),2) as YearDate, Sum(IIF(Year=2006,quantity*price,0)) as YearAmount2006, Sum(IIF(Year=2007,quantity*price,0)) as YearAmount2007
FROM tblSales
WHERE products = 'apples'
GROUP BY salesdate, products, Year(salesdate) & right('00'&Month(salesdate),2)
HAVING Year(salesdate) & right('00' & Month(salesdate),2) IN ('200601','200701')

Getting the idea ?

Nic;o)