access查询

将''改为“#”

SELECT Sum(字段1) AS 表达式1, Sum(字段2) AS 表达式2, Sum(字段3) AS 表达式3, Sum(字段4) AS 表达式4
FROM Moneycounts
WHERE (((Moneycounts.时间) Between (#11/1/2009#) And (#11/11/2009#)));