Group Query results By Months

[Maritza]

How do I get a query to group by months in design view. I need to group by month x and then by field2. If not in Query Design view, what is the best way to write a SQL command for something like that.

Thanks,

Maritza

 

[FoFa]

you could create a calculated column with just the month
CurrMonth: Month([MyDate])

Then use it in your group by

 

[Maritza]

Thanks, It works!