quarterly groupings of dates

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

I have a simple table made up of a monthly default date,
and numbers in four columns of fields that need to be
summed (and perhaps averaged).

How do you group the sums by 3 months at a time?

tblReferral, need to group by dtmMonthReferral.

thanks,

Judy
 
Create a report.
In the Sorting And Grouping box, choose the dtmMonthReferral field.
In the lower pane of the dialog, choose:
Group Footer Yes
Group On Quarter

If you need to do it in a query, use calculated fields to get:
Year([dtmMonthReferral])
DatePart("q", [dtmMonthReferral])
and group on those two.
 
Back
Top