TSCount Function

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 nameRequired. 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).
filterOptional.  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.