Khubaib;
try something like
SELECT;
Cur1.Category,;
COUNT(*) AS nCount;
FROM YourCursor AS Cur1;
INTO CURSOR curCount;
WHERE Cur1.Category=='A';
GROUP BY 1
Agnes
>in my filed (category) records as=A,B,C,A,A,A
>I want to count the records.
>if A,A,A is replaced continuously
>SELECT date,code,lcode,sec, ;
> CAST(sum(IIF(category=="A",1,0)) AS I) A is 3
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]