7,713
社区成员
发帖
与我相关
我的任务
分享
这样老提示 “ Microsoft VBScript 编译器错误 (0x800A0409)
未结束的字符串常量”错误!
--------------------------------------------------------------
把SQL语句直接在Access的查询中执行试试。
--try
select
a.UID,
UNAME,
sum(iif([sign]=1,cj,0)) as CJ1,
sum(cj) cj,
sum(iif([sign]=1,cj,0))*1.0/sum(cj) as radio
from [User] a
left Join [yeji] b on a.UID=b.UID
group by a.UID,UNAME
order by sum(iif([sign]=1,cj,0)) desc
--try
select
a.UID,
UNAME,
sum(iif([sign]=1,cj,0)) as CJ1,
sum(cj) cj,
sum(iif([sign]=1,cj,0))*1.0/sum(cj) as radio
from [User] a
left Join [yeji] b on a.UID=b.UID
group by a.UID,UNAME
order by sum(iif([sign]=1,cj,0)) desc
--下面就是改为access中的SQL语句:
select
a.UID,
UNAME,
sum(iif(sign=1,cj,0)) CJ1,
sum(cj) cj,
sum(iif(sign=1,cj,0))*1.0/sum(cj) radio
from [User] a
left Join [yeji] b on a.UID=b.UID
group by a.UID,UNAME
order by 3 desc