一个简单的问题，高分求教！

[qouoww]

select distinct analysisdept,analysiscustom,analysisname,analysisdate from analysis WHERE analysisdate between #2004-12-3 AND #2004-12-4 order by analysisname DESC
这句sql有什么问题？
如果去掉WHERE analysisdate between #2004-12-3 AND #2004-12-4
就可以，正确的写法是什么呢？
注：access数据库，analysisdate为日期/时间型字段

[阿泰]

between #2004-12-3# AND #2004-12-4#

##之间封闭一个时间的，你把两个全圈在里面了

[dh20156]

TRY:
between '2004-12-3' AND '2004-12-4'

[yaniu]

阿泰正解

[itzhiren]

同意阿泰

[liuyangxuan]

Or
WHERE analysisdate > 2004-12-3 AND analysisdate < 2004-12-4

[tatty_bad]

在SQL里面，Order By 似乎不应该用。

[lishuai818]

同意泰哥~~~~~~

[cheng17]

WHERE (analysisdate >= #2004-12-3# AND analysisdate <= #2004-12-4 23:59:59#)

[zhgroup]

在access中用#,mssql中不能用吧，我记着是不能用.