>I have a table that has a filter. If no records satisfy the filter, how can I tell? The RecCount() shows the number in the table, not just those in the filtered result. I need to know if the filtered result is empty.

SELECT mytable
COUNT
IF _TALLY = 0
  * No records match the filter
ENDIF

* Or

SELECT mytable
LOCATE
IF EOF()
  * No records match the filter
ENDIF