DateGrouping Property

Microsoft Access Visual Basic

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 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.

The sort order used in a report isn't affected by the DateGrouping property setting.