[5分]查询语句有问题

师傅，急用呀，  strsql = "TRANSFORM Sum(tblddspck_dsfsh_ddsl.订单数量) AS 订单数量之总计 SELECT tblddspck_dsfsh_ddsl.记录日期, tblddspck_dsfsh_ddsl.商品类别, tblddspck_dsfsh_ddsl.商品编号, tblddspck_dsfsh_ddsl.商品名称, tblddspck_dsfsh_ddsl.现有库存, Sum(tblddspck_dsfsh_ddsl.订单数量) AS 订单数量总计, Count(([订单数量之总计]<>0 Or Null)) AS 数量计数, Val(IIf(nz([数量计数])=0,"",Round([订单数量总计]/[数量计数],0))) AS 月平均销量, Val(IIf(nz([月平均销量])=0,"",Round([现有库存]/[月平均销量],2))) AS 库存消耗月, Round([库存消耗月]*30,0) AS 库存周转天数, IIf([月平均销量]=0 And [现有库存]>0,"卖不动，待处理") AS 提示 FROM qrycgrk_gys where " & strwhere & " GROUP BY qrycgrk_gys.记录日期, qrycgrk_gys.商品类别, qrycgrk_gys.供应商, qrycgrk_gys.商品编号, qrycgrk_gys.商品名称 PIVOT Format([入库日期],'yyyy/mm');"
这段语句在查询里面用得好好的，一到窗体代码里面就老报错，师傅帮忙看看