select EyeColor, count(eyeColor) from males group by eyecolor
;-)
Hello,
Sorry for the probably newbie question.
Is there a way to show the number of records in a recordset based on a
specific criteria?
For example, if I create a record set of all male employees regardless
of eye color and then I want to create a table showing the totals of
people of each eye color. Is there a way to do this with out creating
several different recordsets.
Thanks!!
Tim Winters
Creative Development Manager
Sampling Technologies Incorporated
1600 Bedford Highway, Suite 212
Bedford, Nova Scotia
B4A 1E8
www.samplingtechnologies.com
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Office: 902 450 5500
Cell: 902 430 8498
Fax:: 902 484 7115
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
