Visual Basic Reference
AggregateType Property
See Also Example Applies To
Returns or sets the type of aggregation.
Syntax
object.AggregateType [=value]
The AggregateType property syntax has these parts:
| Part | Description |
| object | An object expression that evaluates to an item in the Applies To list. |
| value | A constant or value that specifies the type of aggregate, as described in Settings. |
Settings
The settings for value are:
| Constant | Description |
| deGrouping | Grouping. This is only available if the DECommand object is grouped. The FieldToAggregate item can be any field in the current DECommand object. This is because grouping a DECommand object creates two Recordsets: one contains the grouped fields and the other contains the non-grouped fields. |
| deRelation | Relation. The FieldToAggregate item can be any field of the DECommand object that is specified in the AggregateOn property. |
| deGrandTotal | Grand Total. This is only available if the DECommand object is the top-most Command in a hierarchy. If the DECommand object is grouped, only the grouping fields are available. If ungrouped, all fields are available. |