select "创建期初数" as 出入库,货品编码,货品名称, 规格型号,单位,数量 AS 期初数量,单价,金额 AS 期初金额 from[创建期初数$]
union all
select "入库流水账" as 出入库,货品编码,货品名称, 规格型号,单位,sum(数量) As 本月入库数量,单价,sum(金额) As 本月入库金额 from[入库流水账$],[库存查询$A2:A3] where month(日期)=月份) group by 货品编码,货品分类,货品名称,规格型号,计量单位,单价) where (本月入库数量 Is not null ))
union all
select "出库流水账" as 出入库,货品编码,货品名称, 规格型号,单位,sum(数量) As 本月出库数量,单价,sum(金额) As 本月出库金额 from[出库流水账$],[库存查询$A2:A3] where month(日期)=月份) group by 货品编码,货品分类,货品名称,规格型号,计量单位,单价) where (本月出库数量 Is not null ))
union all
select "结存数" as 出入库,货品编码,货品名称, 规格型号,单位,数量 AS 期初数量,单价,金额 AS 期初金额 from[创建期初数$]
union all
select "结存数" as 出入库,货品编码,货品名称, 规格型号,单位,sum(数量) AS 累计入库数量 ,单价,sum(金额) AS 累计入库金额 from[入库流水账$],[库存查询$B2:C3] where 日期 between 起始日期 and 终止日期) group by 货品编码,货品分类,货品名称,规格型号,计量单位,单价)
union all
select "结存数" as 出入库,货品编码,货品名称, 规格型号,单位,-sum(数量) AS 累计出库数量 ,单价,-sum(金额) AS 累计出库金额 from[出库流水账$],[库存查询$B2:C3] where 日期 between 起始日期 and 终止日期) group by 货品编码,货品分类,货品名称,规格型号,计量单位,单价)
连接属性-定义-命令文本-粘贴,提示错误,不知道哪出错,求帮助?? |