Dear Experts

I am planing to convert my Projects from VFP6 to VFP9.
Following command is written in VFP6 and work fine but when I run it into VFP9,
it show following error message

SQL:GROUP BY Clause is missing or invalid

What should I do get rid of this error message.
Please help

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