DateGrouping Property
You can use the DateGrouping property to specify how you want to group dates in a report. Read/write Byte.
expression.DateGrouping
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
For example, using the US Defaults setting will cause the week to begin on Sunday. If you set a Date/Time field's GroupOn property to Week, the report will group dates from Sunday to Saturday.
Note The DateGrouping property setting applies to the entire report, not to a particular group in the report.
The DateGrouping property uses the following settings.
| Setting | Visual Basic | Description |
|---|---|---|
| US Defaults | 0 | Microsoft Access uses the U.S. settings for the first day of the week (Sunday) and the first week of the year (starts on January 1). |
| Use System Settings | 1 | (Default) Microsoft Access uses settings based on the locale selected in the Regional Options dialog box in Windows Control Panel. |
You can set the DateGrouping property only in report Design view or in the Open event procedure of a report.
The sort order used in a report isn't affected by the DateGrouping property setting.