>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