Crosstab: how do I group dates by month?

R

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
 
R

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
 
Top