>>>Michelle,
>>>
>>>

>>>SELECT Zone, Class, COUNT(Class) ;
>>>  FROM MyTable ;
>>> GROUP BY Class ;
>>> ORDER BY Zone, Class ;
>>> INTO CURSOR MyResult
>>>

>>
>>That's slightly different from Ed's. Is there any difference in the results?
>>
>>Thanks,
>>
>>-Michelle
>
>Michelle,
>
>Ed's and mine are variations on the theme. Functionally the saem but written differently.

Works different if null values exist in counted fields:

Select count(myfld1) from mytable && Ignores null values from the count.

Select count(*) from mytable && Includes all rows in the count.

Crescencio