criteria

[Guest]

what criteria do you use to find out how many records
there are in a table

 

[Pat]

Not sure what you mean by criteria (generally a limitting
piece of logic) but this query will return a single
number for the number of records in the table.

SELECT Count(1) AS RecordCount
FROM MyTable;