select 物资编码,物资类别,物资名称,规格型号,计量单位,单价,本月入库数量,本月入库金额,本月出库数量,本月出库金额,0 As 年初库存数量,0 As 年初库存金额,0 As 累计入库数量,0 As 累计入库金额,0 As 累计出库数量,0 As 累计出库金额 from (select * from (select 物资编码,物资类别,物资名称,规格型号,计量单位,单价,sum(入库数量) As 本月入库数量,sum(入库金额) As 本月入库金额,sum(出库数量) As 本月出库数量,sum(出库金额) As 本月出库金额 from (select 物资编码,物资类别,物资名称,规格型号,计量单位,单价,入库数量,入库金额,出库数量,出库金额 from [数据库$],[库存月报$A2:A3] where month(日期)=月份) group by 物资编码,物资类别,物资名称,规格型号,计量单位,单价) where (本月入库数量 Is not null Or 本月出库数量 Is not null))
union all
select 物资编码,物资类别,物资名称,规格型号,计量单位,单价,0 As 本月入库数量,0 As 本月入库金额,0 As 本月出库数量,0 As 本月出库金额,年初库存数量,年初库存金额,累计入库数量,累计入库金额,累计出库数量,累计出库金额 from (select 物资编码,物资类别,物资名称,规格型号,计量单位,单价,sum(年初数量) As 年初库存数量,sum(年初金额) As 年初库存金额,sum(入库数量) As 累计入库数量,sum(入库金额) As 累计入库金额,sum(出库数量) As 累计出库数量,sum(出库金额) As 累计出库金额 from (select 物资编码,物资类别,物资名称,规格型号,计量单位,单价,年初数量,年初金额,入库数量,入库金额,出库数量,出库金额 from [数据库$],[库存月报$B2:C3] where 日期 between 起始日期 and 终止日期) group by 物资编码,物资类别,物资名称,规格型号,计量单位,单价) |