我要查找日期在某一段时间内的记录
sqlstr = "select * from shouqi where date between " & CDate(Text1.Text) & " and " & CDate(Text2.Text)其中date是shouqi表中的日期字段名,可是无论输入什么日期,结果够是eof,为什么呢?
sqlstr = "select * from shouqi where date between " & CDate(Text1.Text) & " and " & CDate(Text2.Text)其中date是shouqi表中的日期字段名,可是无论输入什么日期,结果够是eof,为什么呢?
'数据库为ACCESS:
sqlstr = "select * from shouqi where date between # " & CDate(Text1.Text) & " # and # " & CDate(Text2.Text) & " #"
'数据库为SQL:
sqlstr = "select * from shouqi where date between '" & CDate(Text1.Text) & "' and '" & CDate(Text2.Text) & "'"
或者是
sqlstr="select * from shouqi where date>=#" & CDate(text1.text) & "# and date<=#" & CDate(text2.text) & "#"