老师:请帮我查错。
请帮我找一下原因,因为显示:至少一个参数没有被指定值
sql = "SELECT a.配方单号,b.类别,c.配方数量 as 单批定额量,b.本次配料批数 as 配料批数,b.配方定额数量,b.定额成本金额,b.实际投料数量,b.实际成本金额,b.成品数量,b.实际单位成本,(b.实际投料数量 - b.配方定额数量) as 投料量差,(b.实际成本金额 - b.定额成本金额) as 投料价差 FROM " & _
"(((select distinct 配方单号 from 生产数据) AS a LEFT JOIN (SELECT 配方单号,类别,SUM(本次配料批数) as 配料批数,SUM(配方定额数量),SUM(定额成本金额),SUM(实际投料数量),SUM(实际成本金额),SUM(成品数量),SUM(实际成本金额) / SUM(成品数量) as 实际单位成本,sum(实际投料数量) - sum(配方定额数量) as 投料量差,sum(实际成本金额) - sum(定额成本金额) as 投料价差 FROM 生产数据 where 生产日期 BetWeEn #" & [C3] & "# AND " & "#" & [E3] & "# GROUP BY 配方单号,类别) AS b " & _
"ON a.配方单号=b.配方单号) LEFT JOIN (select 配方单号, SUM(配方数量) as 单批定额量 from 配方数据表 GROUP BY 配方单号) AS c ON a.配方单号=c.配方单号) order by a.配方单号 asc"