Table of contents
Collapse the table of content
Expand the table of content

Report.DateGrouping Property (Access)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

You can use the DateGrouping property to specify how you want to group dates in a report. Read/write Byte.


expression. DateGrouping

expression A variable that represents a Report object.


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.

SettingVisual BasicDescription
US Defaults0Microsoft 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 Settings1(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.

See also


Report Object

© 2018 Microsoft