>I've been wondering this for a while: Is there an accurate way to determine how many records are in a filtered table? RecCount() doesnt' work, it's not affected by filters. _TALLY doesn't work, Filters aren't an SQL command. (or at least Set Filter To isn't).
>
>What am I missing? Surely you don't have to select it to a cursor to find out how many were returned?
>
>TIA!
_tally does work, but you have to COUNT first. SET FILTER doesn't actually process any records.
SET FILTER TO ...
COUNT
? _TALLY
GO TOP
Of course, as many of the other responses stated, you can COUNT directly to a variable.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)