Applies To Report.
Description
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 | Description | Visual Basic |
US Defaults | 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). | 0 |
Use System Settings | (Default) Microsoft Access uses settings based on the locale selected in the Regional Settings Properties dialog box in Windows Control Panel. | 1 |
See Also Date function, GroupOn property.