3305 Main Street Ste 019 Vancouver, WA 98663

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:

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.


Click here for examples.