终极 进销存汇总表
受朱版启发，特作此表与大家分享，可随意改变此表路径。
SQL:
select "期初",规格型号,机器号,数量,0 as 数量3, 0 as 数量2, 金额,0 as 金额3, 0 as 金额2 from [期初$] union all select "入库",规格型号,机器号, 0 as 数量2, 数量,0 as 数量3, 0 as 金额2, 金额,0 as 金额3 from [入库$] union all select "出库",规格型号,机器号, 0 as 数量3, 0 as 数量2,数量, 0 as 金额3, 0 as 金额2,金额 from [出库$]
[ 本帖最后由 BIN_YANG168 于 2009-2-13 14:24 编辑 ]
附件: 您所在的用户组无法下载或查看附件
搜索更多相关主题的帖子:
进销存 汇总表
