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

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, .....