如果他的字段都是6位,加个 "退" 字 的7位的话,还可以简化 Sql = " select left(进货单号,6) ,SUM(进货数量),进货单价,SUM(金额) from [Sheet1$] group by left(进货单号,6),进货单价 " 查询的再简化改成这样 Sql = " select a.进货单号 ,iif(isnull(b.付款金额),a.金额,b.付款金额),iif(isnull(b.付款方式),null,'已付') " _ & " from (select left(进货单号,6) as 进货单号,SUM(金额) as 金额 from [Sheet1$] group by " _ & " left(进货单号,6)) a left join [Sheet1$f1:h3] b on a.进货单号=b.进货单号 " 不过,不看不看的代码通用性最好,一般就是这么用的
[此贴子已经被作者于2008-10-15 20:40:35编辑过] |