Difference between revisions of "COUNT"
Yvonne.milne (Talk | contribs) |
Barrymavin (Talk | contribs) (→See Also) |
||
Line 10: | Line 10: | ||
==See Also== | ==See Also== | ||
− | [[AVERAGE]], [[LOCATE]], [[SEEK]], [[SET DELETED]], [[SET FILTER]], [[SUM]], [[TOTAL]] | + | [[AVERAGE]], [[LOCATE]], [[SEEK]], [[SET DELETED]], [[SET FILTER]], [[SUM]], [[TOTAL]] , [[CALCULATE]] |
==Description== | ==Description== |
Revision as of 21:34, 25 December 2020
Contents
Purpose
Count records in the active table that satisfy a specified condition
Syntax
COUNT [<scope>] TO <memvar>
[FOR <condition>]
[WHILE <condition>]
See Also
AVERAGE, LOCATE, SEEK, SET DELETED, SET FILTER, SUM, TOTAL , CALCULATE
Description
The COUNT command counts the number of records in the active table and stores the total to <memvar>. If no <scope> is specified, ALL records will be counted. If SET FILTER TO is in effect, then only those records that satisfy the filter <condition> are counted. If SET DELETED is ON, then records marked for deletion will not be included in the COUNT.
FOR <condition>
If the for <condition> is used then only the records that satisfy the specified <condition> are counted.
WHILE <condition>
The WHILE clause can be used in conjunction with the SEEK or LOCATE commands to restrict the range of records counted. When the WHILE option is used the <scope> defaults to REST.
Example
use patrons count to nResult for event = "CHOPIN" and date = date()