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.
TSCount( table name , [ filter ])
The TSCount function syntax has these parts:
|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.|
Click here for examples.