昨天见到的如下的一个SQL语句:
Select [项目名称Item] AS 表达式1, Sum(qry月平均详细数据.EMoney) AS EMoney之合计, Round([EMoney]/(Month(Date())-1),2) AS 数值
FROM qry月平均详细数据
GROUP BY [项目名称Item], Round([EMoney]/(Month(Date())-1),2) As 数值;
报错:语法错误(操作符丢失)在查询表达式 ' Round([EMoney]/(Month(Date())-1),2) As 数值
' 中。
经检查 去掉Group by里面 ' As 数值 ' 就可以了
Select [项目名称Item] AS 表达式1, Sum(qry月平均详细数据.EMoney) AS EMoney之合计, Round([EMoney]/(Month(Date())-1),2) AS 数值
FROM qry月平均详细数据
GROUP BY [项目名称Item], Round([EMoney]/(Month(Date())-1),2);