Hello.
I have been on this for several days now and still can't find the proper way to do it.
The closest I have become is getting the monthly sales per product, but if a product had sales in several, say 4, months, the report displays 4 lines, one for every month, instead of writing a single line per product. Besides, I need a comparative field with last year's numbers below each amount.
Now, I found what is called a cross-table query. This works good as long as you have only 3 fields in the query. Next question. One of the fields is obviously MONTH(dateofsale). How can I modify this to show Month of datesale of current year? Also, can a report be based on two different sql statements or queries? Because Im going to need the current year sales and last years sales under it.
Something like:

 Product      Jan         Feb.....      Dec


  Prod1   This year   This year     This year
          Last year   Last year     Last year 

  Prod2   This year   This year     This year
          Last year   Last year     Last year 

My feeling is that a report like this is so de facto that it shouldn't be that hard to make. There should be a wizard for a Monthly sales report :)

Thanks everybody. Any input greately apreciatted by a novice programmer who wants to get better.