probably just a type but shouldn't it be

GROUP BY flockyear,growercode

to get what you described?


>Never mind. I figured it out.
>
>

>SELECT growercode, flockyear, COUNT(fm_grcode) ;
>FROM ;
>(SELECT SUBSTR(fm_flcode,1,4) growercode, fm_grcode, YEAR(fm_hatchdate) flockyear ;
>FROM it!flckmast) fy ;
>GROUP BY growercode, flockyear ;
>INTO CURSOR curs1
>

>
>>Hi All:
>>
>>Given the following data:
>>
>>

>>Grower     Flock
>>Name       Began
>>
>>Grower1	1/4/07
>>Grower2	1/6/07
>>Grower1	3/4/07
>>Grower1	1/4/08
>>Grower2	1/6/08
>>Grower2	3/4/08
>>

>>
>>How would I be able to produce the following report?
>>
>>

>>Number of Flocks Report
>>
>>Grower    Number
>>
>>2007:
>>Grower1   2
>>Grower2   1
>>
>>2008:
>>Grower1   1
>>Grower2   2
>>

>>
>>Thanks,
>>
>>Yossi