Hey guys!
I have a crosstab query that displays a totals for each month of the year. Currently my Column Headings is as follows:
"Jan 2014","Feb 2014","Mar 2014", etc.
Is there a way to use a variable for the year based on a field in my table? The data is only from a calendar year and it would be really nice to not have to manually change this part each year and this would translate other places, as well. I tried entering SELECT DISTINCT MONTH FROM TABLE, but Access didn't like it there.
Ideas?