>Hi Erik,
>
>>>Use the COUNT command
>>... and remember to reset the record pointer afterwards.
>
>Yeah, its one of those try it and you'll see things. Along with, if your filters not optimized, COUNT is goina crawl.
Speaking of crawling, I have several fields I filter on, all of them are indexed, but when I filter on a date field and go beyond the limit of the filter with either skip or skip -1 it takes forever for my focus to come back. Are date fields slower in a filter then text?
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108