access数据计算错误!
SELECT Mid_CompanyPortfolioM.CompanyName AS 公司名,
> left(Mid_CompanyPortfolioM.tMonth,len(Mid_CompanyPortfolioM.tMonth)-2) AS 月
> 份, Mid_CompanyPortfolioM.SendCount AS 业务量,
> Mid_CompanyPortfolioM.CompeteCount AS 竞标数,
> Left(Mid_CompanyPortfolioM.CompeteCount/IIf(Mid_CompanyPortfolioM.SendCount=
> 0,1,Mid_CompanyPortfolioM.SendCount),5)*100 & '%' AS 竞标率,
> Mid_CompanyPortfolioM.WinCount AS 中标数,
> Left((Mid_CompanyPortfolioM.WinCount/IIf(Mid_CompanyPortfolioM.SendCount=0,1
> ,Mid_CompanyPortfolioM.SendCount)),5)*100 & '%' AS 中标率,
> Mid_CompanyPortfolioM.SendCarsCount AS 发单车次,
> Mid_CompanyPortfolioM.CompeteCarsCount AS 竞标车次,
> Left((Mid_CompanyPortfolioM.CompeteCarsCount/IIf(Mid_CompanyPortfolioM.SendC
> arsCount=0,1,Mid_CompanyPortfolioM.SendCarsCount)),5)*100 & '%' AS 车辆竞标
> 率, Mid_CompanyPortfolioM.ComplainCount AS 投诉量,
> Left((Mid_CompanyPortfolioM.ComplainCount/IIf((Mid_CompanyPortfolioM.SendCou
> nt)=0,1,(Mid_CompanyPortfolioM.SendCount))),5)*100 & '%' AS 投诉率
>
> FROM Mid_CompanyPortfolioM
>
> WHERE
> iif([StrCompanyName]="",((((Left([startday],Len([startday])-2))<=(Mid_Compan
> yPortfolioM.tMonth) And
> (Mid_CompanyPortfolioM.tMonth)<=[endday]))),((((Left([startday],Len([startda
> y])-2))<=(Mid_CompanyPortfolioM.tMonth) And
> (Mid_CompanyPortfolioM.tMonth)<=[endday]))) and
> CompanyName=[StrCompanyName]);
>
> 重点就看这一句吧:
> Left(Mid_CompanyPortfolioM.CompeteCount/IIf(Mid_CompanyPortfolioM.SendCount=
> 0,1,Mid_CompanyPortfolioM.SendCount),5)*100 & '%' AS 竞标率,在执行的时候:
> Mid_CompanyPortfolioM.SendCount 的值是11014,
> Mid_CompanyPortfolioM.CompeteCount 的值是1078。但是竟标率却是978.7%。你要是
> 说代码严重错误,但是也有对的啊,比如:Mid_CompanyPortfolioM.SendCount 的值是
> 16013, Mid_CompanyPortfolioM.CompeteCount 的值是9047,结果竞标率是56.49%。
> 我想是不是access里面对于除法有特别的要求呢!?但是其他的我写的查询都没有错误
> 啊 ?请教达人是什么原因如何更改?