Report.DateGrouping Property
| Access Developer Reference |
You can use the DateGrouping property to specify how you want to group dates in a report. Read/write Byte.
Syntax
expression.DateGrouping
expression A variable that represents a Report object.
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.
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. |
.gif "Bb237453.vs_note(en-us,office.12).gif") Note |
|---|
| The DateGrouping property setting applies to the entire report, not to a particular group in the report. |
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.
See Also