[已解决]一段sql查询语句报错

coolabc

SELECT Max(d.dDate) AS 最近销售日期, ds.cInvCode AS 存货编码, Sum(ds.iQuantity) AS 发货数量 INTO 今年发货情况表
FROM dbo_dispatchlist AS d, dbo_dispatchlists AS ds
WHERE (((d.dDate)>'#2008-01-01#'))
GROUP BY ds.cInvCode;

提示说标准表达式中数据类型不匹配！

[ 本帖最后由 coolabc 于 2008-6-5 12:08 编辑 ]

tz-chf

日期不要加单引号

coolabc

SELECT Max(d.dDate) AS 最近销售日期, ds.cInvCode AS 存货编码, Sum(ds.iQuantity) AS 发货数量 INTO 今年发货情况表
FROM dbo_dispatchlist AS d, dbo_dispatchlists AS ds
WHERE (((d.dDate)>#2008-01-01#))
GROUP BY ds.cInvCode;
成功了，感谢！