Columns using month and year

I am trying to create a LAG report that gives what month/year (Jan 2006-Dec
2009) service was given (the rows) to month/year service (again Jan 2006-Dec
2009) was paid for (columns) with the sum of the Net $ as the result. I have
a crosstab query which gives me what I need, except it only will show one
year's worth of months without the year, so if someone get's service in
November it could shows up as paid in January's column, but I need to be able
to cross over the year into a new one without the months from all years being
combined . Is there a way to show more without creating a column with the
month/year combined and using it as the column heading?
--
Thanks, Sheri

On Wed, 25 Nov 2009 14:20:02 -0800, Sheri
wrote:

No.
It's really not that hard to create a table with all months from 2006
to 2016 or whatever, and use that in your query.

-Tom.
Microsoft Access MVP


I am trying to create a LAG report that gives what month/year (Jan 2006-Dec
2009) service was given (the rows) to month/year service (again Jan 2006-Dec
2009) was paid for (columns) with the sum of the Net $ as the result. I have
a crosstab query which gives me what I need, except it only will show one
year's worth of months without the year, so if someone get's service in
November it could shows up as paid in January's column, but I need to be able
to cross over the year into a new one without the months from all years being
combined . Is there a way to show more without creating a column with the
month/year combined and using it as the column heading?