S
Sheri
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?
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?