|
本帖最后由 爱疯 于 2011-10-26 17:24 编辑
按你说的理解了,但结果和你的模拟结果有出入
[hide
]
- SQL = "SELECT 部门名称, 业务员, Count(*), Sum(IIf([问题件类型]='首次转账不成功问题件',1,0)), Format(Sum(IIf([问题件类型]='首次转账不成功问题件',1,0))/Count(*),'0.00%'), " _
- & "Sum(IIf(DateDiff('d',[二次到期日期],[二次交费日期])<=3,1,0)), Format(Sum(IIf(DateDiff('d',[二次到期日期],[二次交费日期])<=3,1,0))/Count(*),'0.00%'), Sum(IIf(Month([二次到期日期])=Month([二次交费日期]),1,0)), Format(Sum(IIf(Month([二次到期日期])=Month([二次交费日期]),1,0))/Count(*),'0.00%'), " _
- & "Sum(IIf(DateDiff('d',[三次到期日期],[三次交费日期])<=3,1,0)), Format(Sum(IIf(DateDiff('d',[三次到期日期],[三次交费日期])<=3,1,0))/Count(*),'0.00%'), Sum(IIf(Month([三次到期日期])=Month([三次交费日期]),1,0)), Format(Sum(IIf(Month([三次到期日期])=Month([三次交费日期]),1,0))/Count(*),'0.00%'), " _
- & "Sum(IIf(DateDiff('d',[四次到期日期],[四次交费日期])<=3,1,0)), Format(Sum(IIf(DateDiff('d',[四次到期日期],[四次交费日期])<=3,1,0))/Count(*),'0.00%'), Sum(IIf(Month([四次到期日期])=Month([四次交费日期]),1,0)), Format(Sum(IIf(Month([四次到期日期])=Month([四次交费日期]),1,0))/Count(*),'0.00%') " _
- & "FROM [销售明细$a2:y] WHERE (保单状态 Is Not Null) and 扫描时间 between #" & TD1 & "# AND #" & TD2 & "# GROUP BY 部门名称,业务员"
复制代码
销售报表.rar
(11.13 KB, 下载次数: 329)
|
|