dim sql as strin = "select 店名,店铺地址,sum(提成实收金额) as (提成实收金额),sum(实收金额) as 实收金额 From 销售合计 where 日期 >= '" & e.PostValues("开始") & "' And 日期 <= '" & e.PostValues("结束") & "' And ('," & ddr("账号企业名") & ",') like '%,' + 店名 + ',%' and 商品素金非素='非素' group by 店名,店铺地址"