About grouping records on date or time values in a report

When you group records in a field that stores date or time values, you set the GroupOn property to one of the ranges listed in the following table. In a Microsoft Access database (.mdb), you store date or time values in field with a Date/Time data type. In a Microsoft Access project (.adp), you store them in a column with a datetime or smalldatetime data type. For all ranges except Each Value, you can set the GroupInterval property to any number that is valid for the values in the field or expression you're grouping on. If you set the GroupOn property to Each Value, the GroupInterval value is 1.

Set the GroupOn property to	To group records with

Each Value	The same value in the field or expression.
Year	Dates in the same calendar year.
Qtr	Dates in the same calendar quarter.
Month	Dates in the same month.
Week	Dates in the same week.
Day	Dates on the same day.
Hour	Times in the same hour.
Minute	Times in the same minute.

Report that groups date values by year and quarter

The following table lists the main sorting and grouping specifications for this report. Shipped Date in the first row of the Field/Expression column in the Sorting And Grouping box groups the records by year. Shipped Date in the second row groups the records for each year by quarter.

Field/ Expression	Sort Order	Group Header	Group Footer	Group On	Group Interval	Keep Together
Shipped Date	Ascending	Yes	Yes	Year	1	Whole Group
Shipped Date	Ascending	No	Yes	Qtr	1	No

Notes

To print the year or quarter instead of a specific date, use the DatePart function or use the Format function.
To count the number of orders shipped, use the Count function.
The Summary of Sales by Year report in the Northwind sample database prints quarterly sales for each year. To view this report, open the Northwind database in the Samples subfolder of your Office folder, and then open the Summary of Sales by Year report in Design view. For information on opening Northwind, click .
The Summary of Sales by Quarter report in the Northwind sample database shows sales from multiple years for each quarter. To view this report, open the Northwind database in the Samples subfolder of your Office folder, and then open the Summary of Sales by Quarter report in Design view.