Summary Query Group by Month 1

[BarbDataRUs]

I have a simple table tracking number of hours worked per day need to be able to present (and graph) number of hours per month. In the past I've made queries of this type by grouping by "year" (using DatePart) and then by "month" (also using DatePart) but there's gotta be a simpler (and more elegant) solution I'm just missing. I know exactly how to do this in Crystal reports, but Access is making my brain hurt.

 

[Golom]

Try grouping by

    Format ( DateField, "yyyy/mm" )

 

[BarbDataRUs]

Perfect! Thank you.