>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
ENDIF
SELECT mytable
LOCATE
IF EOF()
ENDIF
--sb--