quarterly groupings of dates

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
 
A

Allen Browne

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.
 

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

Top