Thread: Group by query question

How would I group by month if I have a set of dates in the individual fields? Essentially I have data that I want to group by month in the "dates" column and then perform sum of expenses in the "expenses" column. I know it's a very simple question.

Hi eonizuka,

Group By this as a Calculated Field in the query:

Code:

SumMonth: Year([Dates]) & " " & MonthName(Month([Dates]))

you may also want to use this to give it a chronological sort:

Code:

SumMonthSort: Year([Dates]) & " " & Month([Dates])

you won't need to display the sort.

Cheers,

Hi eonizuka,

Happy to help.

Put the SumMonth in as a new/empty column in the Field row. Use it in place of your "contractdate" with the "Group By" in the Totals row.

Code:

SumMonth: Year([contractdate]) & " " & MonthName(Month([contractdate]))

Cheers,