用VB开发:MSSQL库中
Ssql = "SELECT ClientID, ClientName, ISNULL(SUM(SNum), 0) AS Expr1, ISNULL(SUM(SMoney), 0) AS Expr2, " & _
"ISNULL(SUM(BSNum), 0) AS Expr3, ISNULL(SUM(BSMoney), 0) AS Expr4, " & _
"ISNULL(SUM(SNum), 0) - ISNULL(SUM(BSNum), 0) AS factNum, " & _
"ISNULL(SUM(SMoney), 0) - ISNULL(SUM(BSMoney), 0) AS factmoney " & _
"From dbo.ProSellList GROUP BY ClientID, ClientName"
现在以ACCESS运行时出现不支持,问题是:
在ACCESS中提示 ISNULL(SUM(BSNum), 0) 这种类型的函数不对
ISNULL()是用来当求出此数的和为0或不存在时返回0
不知在ACCESS中应怎样表达??
高手们......指教...
Ssql = "SELECT ClientID, ClientName, ISNULL(SUM(SNum), 0) AS Expr1, ISNULL(SUM(SMoney), 0) AS Expr2, " & _
"ISNULL(SUM(BSNum), 0) AS Expr3, ISNULL(SUM(BSMoney), 0) AS Expr4, " & _
"ISNULL(SUM(SNum), 0) - ISNULL(SUM(BSNum), 0) AS factNum, " & _
"ISNULL(SUM(SMoney), 0) - ISNULL(SUM(BSMoney), 0) AS factmoney " & _
"From dbo.ProSellList GROUP BY ClientID, ClientName"
现在以ACCESS运行时出现不支持,问题是:
在ACCESS中提示 ISNULL(SUM(BSNum), 0) 这种类型的函数不对
ISNULL()是用来当求出此数的和为0或不存在时返回0
不知在ACCESS中应怎样表达??
高手们......指教...
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货