 加好友  发短信
等级：九尾狐
帖子：2552
积分：20057
威望：0
精华：0
注册：2012/5/19 11:57:00
|
 Post By：2017/7/3 20:40:00 [只看该作者]
我用Tables(e.form.Name & "_Table1").fill("s lect 期初数量 as 期初数量,入库数量, 出库数量,(isnull(期初数量,0)+isnull(入库数量,0)-isnull(出库数量,0)) as 库存数量, a.* from (SE LECT * FROM 产品目录表 WHERE 停用=0) a left join (Sel ect 产品编码, sum(入库数量) As 入库数量, sum(出库数量) As 出库数量 from (Sel ect 产品编码, 数量 As 入库数量, 0 As 出库数量 from {进货单明细} where " & exp & " union all Sel ect 产品编码,数量,0 from {其他入库单明细} where " & exp & " union all Se lect 产品编码,数量,0 from {调拨单明细} where " & ck2 & " union all Sel ect 产品编码, 0, 数量 from {销售单明细} where " & exp & " union all S elect 产品编码, 0, 数量 from {其他出库单明细} where " & exp & " union all Sele ct 产品编码, 0, 数量 from {调拨单明细} where " & ck1 & ") as d group by 产品编码) As b on a.产品编码 = b.产品编码","wjhansdata",True)
|
|
