The TSCount function counts the number of records in a specific table. Conditions may be applied to limit which records are included in the total.
Syntax
TSCount( table name , [ filter ])
The TSCount function syntax has these parts:
| Argument | Description |
|---|---|
| table name | Required. This argument identifies an SQL statement or a specific internal table name in the Timberline Office database. If this argument does not supply a valid source of data, then the result of the function will be #TABLE? ("table name" not found). |
| filter | Optional. A filter is a string of text that includes comparisons between fields in the table and specific values. Only the records that satisfy the filter conditions will be used to return values. |
Example
Click here for examples.