>If let say 45 records are true, and I set the filter to active=.t. How

>do I know how many records would be available (45 in this example)

Matt already gave you two methods (using COUNT TO and _tally), but it

always makes me twitchy to do an aggregate function on a database and only

look for one item. So you may also want to look at the CALCULATE command.

CALCULATE can run a set of calculatons, including counts, average,

maximums, minimums, net present values, standard deviations, sums, and

variances. Maybe more too, but that's all that comes to mind off the top

of my head.

Joel

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/14266C50D0C5496D92D991D5DA6E30BB@ASUS1

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.