请教各位在线的大虾，这是错在那里啊？

[zqonline]

Dim frmDateStar As Date
Dim frmDateEnd As Date
frmDateStar = CDate("2003-12-13 00:00")
frmDateEnd = CDate("2003-12-13 23:59")
Adodc2.RecordSource = "select * from tusers where dtAccount between #" & frmDateStar & "# and #" & frmDateEnd & "#"
为什么返回为0条记录
Adodc2.RecordSource = "select * from tusers where dtAccount between #2003-12-13 00:00# and #2003-12-13 23:59#"
这条又是对的。
我的数据库是：ACCESS2000
因为字段:dtAccount是日期/时间的，值都是：03-12-13 15:00:35这种格式的。
要怎样写才能查出现这一天的记录啊？

[lxqlogo0]

应该没错啊，你这样试试

frmDate = CDate("2003-12-13")
Adodc2.RecordSource = "select * from tusers where dtAccount like #" & frmDateStar & "%#"

[huntgirl]

up

[fancyong]

Dim frmDateStar As Date
Dim frmDateEnd As Date
frmDateStar = CDate("2003-12-13 00:00")
frmDateEnd = CDate("2003-12-13 23:59")
Adodc2.RecordSource = "select * from tusers where dtAccount between #'" & frmDateStar & "'# and #'" & frmDateEnd & "'#"
为什么返回为0条记录
Adodc2.RecordSource = "select * from tusers where dtAccount between #2003-12-13 00:00# and #2003-12-13 23:59#"

你试着在#的前面可后面都加上'，或许就可以了。
这个问题我也遇到过！