I'd set up 3 queries, the first gets the first year/month data, the second
gets the comparison year/month, the third query combines the two other
SELECT Year, Month, Sales From SalesTable WHERE Year = 2006 and Month = 1
SELECT Year, Month, Sales From SalesTable WHERE Year = 2007 and Month = 1
SELECT Query1.Month, Query1.Year, Query1.Sales, Query2.Year, Query2.Sales
From Query1, Query2 WHERE Query1.Month = Query2.Month ORDER BY Query2.Month
Of course you can build these queries in VB and so have the Year and Month
be varied each time.