>SQL:GROUP BY Clause is missing or invalid

>

>SELECT *,;
>	SUM(IIF(Mode="B",BAGS,0))AS BAGS,;
>	SUM(IIF(Mode="L",BAGS,0))AS LOSE,;
>	SUM(WEIGHT) AS unfix_kg,;
>	SUM(W_KG) AS unfix_a;
>	WHERE BETWEEN(DATE,F_DATE1,T_DATE1);
>	FRoM AVLBOOK;
>	ORDER BY ACC_CODE;
>	GROUP BY ACC_CODE;
>	INTO CURSOR XYZ
>

Replace the * with ACC_CODE in your SELECT field list. Also, you can SET ENGINEBEHAVIOR 70 prior to the command and leave as is.