On Tue, Dec 9, 2008 at 6:31 AM, Jim Harvey <[EMAIL PROTECTED]> wrote: > Yes, I'm trying to get the count of the group headers (the number of > distinct groups in the resultant cursor created by the select statement). ------------------
do you need the total in the header or in the footer? Customer: ABC Total Invoices 8 inv 1234 inv 1344 or in the footer? Customer ABC inv 1234 inv 1344 ......... --------------------------------------------------------------------------- Total Invoices 8 Cathy has given the way to get the total to a var and use it in your footer. If you need the total in the Header of the group like a treeview type of pres, -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 _______________________________________________ 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/[EMAIL PROTECTED] ** 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.