Field type

Operation

integer

real

string

date, time, timestamp

Boolean

Count

yes

yes

yes

yes

yes

Not empty

yes

yes

yes

yes

yes

Empty

yes

yes

yes

yes

yes

Minimum

yes

yes

no

yes

no

Maximum

yes

yes

no

yes

no

Average

yes

yes

no

no

no

Sum

yes

yes

no

no

no

True

no

no

no

no

yes

False

no

no

no

no

yes

Operation

Description

Count

Total number of records in a query is calculated

Not empty

Number of query records containing not empty value in the field is calculated

Empty

Number of query records containing empty value in the field is calculated

Minimum

Minimum field value among query records is determined, records with empty field value are not taken into account.

Maximum

Maximum field value among query records is determined, records with empty field value are not taken into account

Average

Average field value by records in a query is calculated, records with empty field value are not taken into account

Sum

Sum of field values in query records is calculated, records with empty field value are not taken into account

True

Number of query records having the field value True is calculated, records with empty field value are not taken into account

False

Number of query records having the field value False is calculated, records with empty field value are not taken into account

OK

Closes the dialog box.