Report by quarters of the year

J

jsrogol

I'm trying to find an easy way to separate data within a report by quarters
in a year. I seem to remember that access could do that many years ago. I
know I can ask the user to enter data into a form to select the parameters
but would prefer to just have the report run and give ALL quarters.

Any ideas. Thanks in advance for any help.

Jsrogol
 
A

Allen Browne

Say your table has a Date/Time field named SaleDate, and you want quarterly
subtotals in your sales report.

1. In report design view, open the Sorting And Grouping pane. (Grouping &
Totals chunk of the Design ribbon.)

2. In the Sorting and Grouping pane (bottom of report design, choose:
Group on: SaleDate from oldest to newest by quarter

Then create a Group Footer, and you can sum the sales for the quarter.
 
Top