Crosstab: how do I group dates by month?

[Rachel Garrett]

I have a crosstab query where the dates are the column headings. What
is the best way to group them by month?

I found a Microsoft article talking about how to use the Switch
command in SQL, but I am hesitant to do this because I don't want to
break the date formatting. Since grouping is built into PivotTables,
it seems like something that a crosstab query would have something
built-in to handle.

Thanks,
Rachel

 

[Rachel Garrett]

Never mind again...I used the wizard to recreate the same query and it
allowed me to add groupings. According to SQL, it involves Pivot and
Format.

Thanks,
Rachel