Dear Sir,

I added "," between sums according to your advise as follows

SELECT MONTH(date) as nmonth,;
	CMONTH(date) as cmonth,;
	YEAR(date) as nyear;
	sum(weight) as weight;
	sum(iif(mode="L",weight,1,0)) as bagsLC, ;
	sum(iif(mode="b",weight,1,0)) as bagsLS;
	from avlbook;
	GROUP BY nmonth,nyear ;
	ORDER BY nyear,nmonth;
	INTO CURSOR Temp

But the problem is still exists as

Command contains unrecognized command/phrase...

Please modify my codes again

Thnaks