GroupInterval Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

                 

You can use the GroupInterval property with the GroupOn property to specify how records are grouped in a report. The GroupInterval property specifies an interval value that records are grouped by. This interval differs depending on the data type and GroupOn property setting of the field or expression you're grouping on. For example, you can set the GroupInterval property to 1 if you want to group records by the first character of a Text field, such as ProductName.

Setting

The GroupInterval property settings are Integer values that depend on the field's data type and its GroupOn property setting. The default GroupInterval setting is 1.

You can set this property by using the Sorting And Grouping box, a macro, or .

You can set the GroupInterval property only in report Design view or in the event procedure of a report.

Remarks

Here are examples of GroupInterval property settings for different field data types.

Field data type	GroupOn setting	GroupInterval setting
All	Each value	(Default) Set to 1.
Text	Prefix characters	Set to 3 for grouping by the first three characters in the field (for example, Chai, Chartreuse, and Chang would be grouped together).
Date/Time	Week	Set to 2 to return data in biweekly groups.
Date/Time	Hour	Set to 12 to return data in half-day groups.

To set the GroupInterval property to a value other than its default setting (1), you must first set the GroupHeader or GroupFooter property or both to Yes for the selected field or expression.