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 TempBut the problem is still exists as
Command contains unrecognized command/phrase...Please modify my codes again