12 Month's Of Data

I'm looking for a starting point for this query.

I currently have a table "tblMonth" with the fields: product, year and each month (Jan, Feb, Mar, Apr, etc.)

I enter month volumes into this table which is used to calculate savings amounts. Currently I create queries that show the month data for each month for 2006. Each month is a column header and I just have 2006 in the "Year" column at this point.

I now need to create another one that will show data for the current month plus the next 11 months, August 2006 through July 2007. In my tblMonth table I just add the product again for the year 2007 and enter the data so I will have two rows of data for each product.
How can I get my query to show 2007 data as well with the column headings beginning at Aug and ending at July 2007?

I can create the data but Jan 2006 and Jan 2007 are in the same column.

I'm sure it's easy, just can't wrap my brain around the concept yet.

Thanks