Tariq,

That error on a SQL usually means one of three things

1) you are missing a ; at the enf of the line
2) you are missing a , between each of the columns
3) you have an extra , in the column list

you are still missing two commas after nyear and weight

>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