Access里面的时间比较怎么写？谢谢！在线等待！

[littleyy]

SELECT *
FROM R1
where selldate
> Cdate(2003-1-1)
and
selldate
<
Cdate(2003-10-10)

不能得到结果。怎么错了
？

[孟子E章]

SELECT *
FROM R1
where selldate
> Cdate('2003-1-1')
and
selldate
<
Cdate('2003-10-10')

[littleyy]

谢谢
！

[webdesigning]

举例：
sql="delete from table where write_time < #"&dat&"#"

时间比较需要加"#"

[lovehwq21]

用这个吧
SELECT * FROM R1
where selldate> #Cdate('2003-1-1')# and selldate<#Cdate('2003-10-10')#
或者
SELECT * FROM R1
where selldate between #2003-1-1# and #2003-10-10#
最后的实现机制就是
where selldate> #2003-1-1# and selldate<#2003-10-10#
或者
where selldate between #2003-1-1# and #2003-10-10#