select * from (select 一级分类,二级分类,日期,型号,名称,数量 as 期初数量,吊牌金额 as 期初金额 ,0 as 调入数量,0 as 调入金额 ,0 as 调出数量,0 as 调出金额,0 as 销售数量,0 as 销售金额 from [期初$] union all select 一级分类,二级分类,日期,型号,名称,0 as 期初数量,0 as 期初金额 ,数量 as 调入数量,吊牌金额 as 调入金额 ,0 as 调出数量,0 as 调出金额,0 as 销售数量,0 as 销售金额 from [调入$] union all select 一级分类,二级分类,日期,型号,名称,0 as 期初数量,0 as 期初金额 ,0 as 调入数量,0 as 调入金额 ,数量 as 调出数量,吊牌金额 as 调出金额,0 as 销售数量,0 as 销售金额 from [调出$] union all select 一级分类,二级分类,日期,型号,名称,0 as 期初数量,0 as 期初金额 ,0 as 调入数量, 0 as 调入金额 ,0 as 调出数量,0 as 调出金额,数量 as 销售数量,实收金额 as 销售金额 from [销售$]) where 日期 <=(select * from [进销存汇总表$A1:A2])想问下楼主,跨月后期初数量如何结转?如果是全年数据都在一起,如果要查询一段期间的进销存,期初数值又有什么办法得到? |