SQL语句语法错误,恳请支持!!!

[bujingyun]

用asp+access做网页,access数据中包括一张表(event),
包含字段:e_creattime,e_status,e_number .......

需要实现功能:
用SQL语句实现查找某个时间段内的记录,但是用如下语句出现语法报错:
sql = "select * from event where creattime<=#"&date&"# && creattime>#"&date-1&"# and <>'close' order by number desc"
creattime<=#"&date&"# && creattime>#"&date-1&"# 语法错误.

请问应该怎么写,各位帮帮忙!感激不尽!

[sy_binbin]

creattime<=#"&date&"# && creattime>#"&date-1&"#

creattime<=#"&date&"# and creattime>#"&date-1&"#

[itzhiren]

sql = "select * from event where creattime<=#"&date&"# && creattime>#"&date-1&"# and <>'close' order by number desc"
creattime<=#"&date&"# && creattime>#"&date-1&"# 语法错误.


这条语句问题很多，不光是creattime<=#"&date&"# && creattime>#"&date-1&"# ，还有and <>'close'
<>'close'前面怎么没有字段名？！

[sotwind]

sql = "select * from event where creattime between #"&date&"# and #"&date-1&"# and 什么<>'" & close & "' order by number desc"

没明白

[playwarcraft]

sql = "select * from event where creattime<=#"&date&"# && creattime>#"&date-1&"# and <>'close' order by number desc"

&&改為and , 'close'前面沒字段名,&date-1&是什麼?變量嗎?如果只是date是變量,可以直接-1嗎??

[sotwind]

不能噢 date也是函数

应该用 dateadd函数计算时间
刚才我也疏忽了 呵呵