Access 表和查询 数据表视图的合计行计算可使用的聚合函数

0 = Sum (合计）

1 = Average (平均值）

2 = Count (计数）

3 = Maximum (最大值)

4 = Minimum (最小值)

5 = Standard Deviation (标准偏差)

6 = Variance (方差)

特别注意 : 可选的聚合函数取决于你选择的列的数据类型（字段类型）;

AutoNumber = None / Count

Text = None / Count

Date = None / Average / Count / Maximum / Minimum

Number = None / Sum / Average / Count / Maximum / Minimum / Standard Deviation / Variance

Currency = None / Sum / Average / Count / Maximum / Minimum / Standard Deviation / Variance

Yes/No = None / Count

OLEObject = None / Count

Hyperlink = None / Count

Attachment = None / Count

Memo = None / Count