[Access 2000]

When sorting and grouping your report data based on a Date/Time field, you can summarize your data in terms other than individual dates. As an example, you may want to group data by month, quarter or year. Fortunately, you won't need to use expressions to accomplish this. Here's how:

1. In Design view and from the menu bar, select View | Sorting And Grouping.
2. Select the appropriate field in the Field/Expression column of the Sorting And Grouping dialog box.
3. Click in the Group On text box and choose one of the following items from the dropdown menu:
   Hour
   Qtr
   Year
   Month
   Week
   Day
   Minute
4. Close the Sorting And Grouping dialog box.