>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: [email protected] 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.
