You can use the DateGrouping property to specify how you want to group dates in a report. 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.
Setting
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 Settings Properties dialog box in Windows Control Panel. |
You can set this property by using the report's property sheet, a macro, or Visual Basic.
You can set the DateGrouping property only in report Design view or in the Open event procedure of a report.
Remarks
The sort order used in a report isn't affected by the DateGrouping property setting.