>Dear Experts
>
>

>SELECT AVLBOOK
>SUM For Mode='B' BAGS To B
>SUM For Mode='L' BAGS To L
>

>I want to use above lines in SELECT statement
>I wrote follwing lines but do not work please modify
>

>SELECT *;
>	FORM AVLBOOK;
>	SUM(IIF(BAGS,Mode="B",1,0)AS B;
>	SUM(IIF(BAGS,Mode="L",1,0)AS L;
>	ORDER BY ACC_NO;
>	GROUP BY ACC_NO;
>	INTO CURSOR XYZ
>

>Field Bags is numeric
>Filed Mode is character
>
>please help

SELECT *,;
	SUM(IIF(Mode="B",BAGS,0)AS B,;
	SUM(IIF(Mode="L",BAGS,0)AS L;
	FORM AVLBOOK;
	ORDER BY ACC_NO;
	GROUP BY ACC_NO;
	INTO CURSOR XYZ