GROUP BY flockyear,growercodeto get what you described?
>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 >>
>>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 >>>>
>>Number of Flocks Report >> >>Grower Number >> >>2007: >>Grower1 2 >>Grower2 1 >> >>2008: >>Grower1 1 >>Grower2 2 >>>>