Report by quarters of the year

  • Thread starter Thread starter jsrogol
  • Start date Start date
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
 
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.
 
Back
Top