If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Columns using month and year
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? |
Thread Tools | |
Display Modes | |
|
|