>Try:

Select crsprod, crsitemcode, sum(crsrequestamt) as inreq, sum(crsaccptamt) as whsaccpt, Count(*) as cntdup From crs_grid1 ;
>    Group By  crsprod, crsitemcode WHERE COUNT(*) > 1 INTO CURSOR dupcount

HTH
>
>>I am trying to select record that have more than 1 duplicate record into a cursor but I keep getting a message saying "SQL : Column 'CNTDUP' not found". Here is my select statement:

Select crsprod, crsitemcode, sum(crsrequestamt) as inreq, sum(crsaccptamt) as whsaccpt, Count(*) as cntdup From crs_grid1 ;
>    Group By  crsprod, crsitemcode WHERE cntdup > 1 INTO CURSOR dupcount

>Is it not possible to use where clause on the count column.

When you use a query result to filter records you must use HAVING clause not where:

Select crsprod, crsitemcode, sum(crsrequestamt) as inreq,;
       sum(crsaccptamt) as whsaccpt, Count(*) as cntdup;
From crs_grid1 ;
Group By  crsprod, crsitemcode;
HAVING cntdup > 1;
INTO CURSOR dupcount

or

Select crsprod, crsitemcode, sum(crsrequestamt) as inreq,;
       sum(crsaccptamt) as whsaccpt, Count(*) as cntdup;
From crs_grid1 ;
Group By  crsprod, crsitemcode;
HAVING COUNT(*) > 1;
INTO CURSOR dupcount