|
楼主 |
发表于 2024-5-21 09:50
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sele_str = "SELECT A.dt,A.dapt,A.dgqty,A.dgamt,b.dgqty,bgamt,b. yjqty,b.yjamt " & _
"FROM (Select 验收日 as dt ,大类名称 as dapt ,SUM(订购数) as dgqty ,SUM(订购数*进价) as dgamt From [Sheet2$] Where 库存方式 = '02 通过型' group by 验收日,大类名称) AS A " & _
"Left JOIN (Select 验收日 as dt ,大类名称 as dapt ,SUM(订购数) as dgqty ,SUM(订购数*进价) as dgamt ,SUM(预拣数) as yjqty,SUM(预拣数*进价) as yjamt From [Sheet2$] Where 单据类型 = '16 店铺进货单' And 库存方式 = '02 通过型' group by 验收日,大类名称) AS B " & _
"ON A.dt=B.dt,A.dapt=B.dapt "
这个在VBA中执行报错了 |
|