sql="select * from TABLE where KAIHU between Cdate(" & dtpicker1.value& " ) and Cdate(" & dtpicker2.value & ")" Use Cdate function in the sql string.
兄弟,把between后的'去掉就行了,''在sql中是专用来应用字符型数据的。 给分吧:)
Access: sql="select * from TABLE where KAIHU between #" & dtpicker1.value & "# and #" & dtpicker2.value & "#" SQL Server: sql="select * from TABLE where KAIHU between '" & dtpicker1.value & "' and '" & dtpicker2.value & "'" DBF: sql="select * from TABLE where KAIHU between { d '" & dtpicker1.value & "' } and { d '" & dtpicker2.value & "' }"
ORACLE: sql="select * from TABLE where to_char(KAIHU,'yyyymmdd') between '" & dtpicker1.value & "' and '" & dtpicker2.value & "'" 或 sql="select * from TABLE where to_char(KAIHU,'yyyy-mm-dd') between '" & dtpicker1.value & "' and '" & dtpicker2.value & "'" 根据变量形式而变
总之在SQL语句中把KAIHU转换成字符型再比就行了
sql="select * from TABLE where KAIHU between '" & format(dtpicker1.value,"yyyy-mm-dd") & "' and '" & format(dtpicker2.value,"yyyy-mm-dd") & "'"
Add the # of your date string. You had better test you SQL statements first in the Access query sql view. then write it into your source code.
给分吧:)
sql="select * from TABLE where KAIHU between #" & dtpicker1.value & "# and #" & dtpicker2.value & "#"
SQL Server:
sql="select * from TABLE where KAIHU between '" & dtpicker1.value & "' and '" & dtpicker2.value & "'"
DBF:
sql="select * from TABLE where KAIHU between { d '" & dtpicker1.value & "' } and { d '" & dtpicker2.value & "' }"
sql="select * from TABLE where to_char(KAIHU,'yyyymmdd') between '" & dtpicker1.value & "' and '" & dtpicker2.value & "'"
或
sql="select * from TABLE where to_char(KAIHU,'yyyy-mm-dd') between '" & dtpicker1.value & "' and '" & dtpicker2.value & "'"
根据变量形式而变
You had better test you SQL statements first in the Access query sql view. then write it into your source code.