Edit

Share via

Report.DateGrouping property (Access)

  • Article

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.

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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.