Crosstab help needed

[ausmoran]

I need to develop a crosstab query that will include multiple values. The wizard allows me to set up a crosstab for every month in a particular year. But what I need to do is create columns for different months and or years. Is this possible?

Thanks in advance,
Austin

 

[Pat Hartman]

You could make the years into rows by selecting just the year part of the date and using it as a row header. Or you could extract the year and month into a single field and use that as the column header. Then use the query as the recordsource for the crosstab rather than a table.

Select Year(YourDate) As YourYear,....

Select Format(YourDate,"yyyy/mm") As YourYearMonth, .....