Export (0) Print
Expand All
A
Expand Minimize

Visual Basic Reference

Visual Studio 6.0

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.

Show:
© 2014 Microsoft