如何对access中日期进行比较查询？

[banban1982]

现在我再vb中用了sql查询
str = " select * from bym where " + Combo1.Text + Combo2.Text + Text1.Text

其中combo1.text是日期（字段名），combo2.text是>,=,<中的1个，text1.text是输入的日期
怎么进行比较？日期格式好像不大对！sql语句那里错了么？

[banban1982]

str = " select * from bym where " + Combo1.Text + Combo2.Text + CDate(Text1.Text)

str = "select * from bym where " + Combo1.Text + Combo2.Text + "'" + Text1.Text + "'"

这2种写法也不对阿，另外说一下access中日期是这样的，如1995-6-3

[online]

'strsql = "select * from test where sj between # " & Text2.Text & " # and # " & Text3.Text & " #"
'strsql = "select * from test where sj between # " & DTPicker1.Value & " # and # " & DTPicker2.Value & " #"
strsql = "select * from test where sj >= # 2004-04-01 # and sj<= # 2004-06-24 #"

举了4种情况
strsql = "select * from test where " & Combo1.Text & " " & Combo2.Text & " # " & Text1.Text & "#"

[饮水需思源]

'数据库为ACCESS
strsql = "select * from test where " & Combo1.Text & " " & Combo2.Text & " # " & Text1.Text & "#"

'数据库为SQL
strsql = "select * from test where " & Combo1.Text & " " & Combo2.Text & " '" & Text1.Text & "'"

[banban1982]

日期
1995-6-3
1995-6-5
1995-6-6
1995-6-9
数据库中有这几个记录，可是我按照你们给的strsql = "select * from bym where " & Combo1.Text & " " & Combo2.Text & " # " & Text1.Text & "#"

查不出记录。。为什么?
我用的 Set querydef1 = db.CreateQueryDef("", str)
Set rs = querydef1.OpenRecordset()
rs.movefirst
可是显示没有当前记录，在数据库中明明是有的

[banban1982]

解决了，不好意思，是我笔误了

[饮水需思源]

'这样试试：
strsql = "select * from bym where " & Combo1.Text & " " & Combo2.Text & " # " & format(Text1.Text,"YYYY-MM-DD") & "#"

[online]

strsql = "select * from test where sj >= # 2004-04-01 # and sj<= # 2004-06-24 #"
这样查询有没有数据啊？？？？