Column Totals allows users to display various totals of the selected field. Selecting multiple records will provide totals for only those records. If multiple records are not selected, the column count will begin from the current record to EOF.
To total all records, start from BOF.
Column Total support all field types. See below to determine how each type is displayed.
Sum
Numeric:
The values for each record for the selected column are totaled
String,Memo:
The number of non empty strings
Logical: N/A
Date:
Number of non empty dates
Low Numeric:
The lowest value of the summed values
String,Memo: N/A
Logical:
Count of records that equal False
Date: (see LDate below)
High Numeric:
The highest value of the summed values
String,Memo: N/A
Logical:
Count of records that equal True
Date: (see HDate below)
Avg Numeric:
The average value of the summed values
String,Memo:
Average string length
Logical: N/A
Date: N/A
Count All Field Types:
Number of records used
Short Numeric: N/A
String,Memo:
The shortest string length
Logical: N/A
Date: N/A
Long Numeric: N/A
String,Memo:
The longest string length
Logical: N/A
Date: N/A
Empty All Field Types:
The number of records that contain no value or (zero)
LDate Numeric: N/A
String,Memo: N/A
Logical: N/A
Date:
The earliest date value
HDate Numeric: N/A
String,Memo: N/A
Logical: N/A
Date:
The latest date value
You are reading help file online using chmlib.com
If you want your help file to be removed or added please send e-mail to chmlibcom@gmail.com
