Crosstab: how do I group dates by month?

  • Thread starter Thread starter Rachel Garrett
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab By Date (Month) 5
Grouping by month and year in crosstab, without losing date value 2
Values in crosstab represent change -- how to get query to return"current value" for each month? 1
Help on crosstab query 2
Crosstab Groupings 2
Date Sorting in Crosstab 3
Crosstab Conundrum 4
crosstab query? 12

Back
Top