"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 "
"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 "'"
"select * from 表1 where [日期] between '#" & date1 & "#' and '#" & date2 "#'"
"select * from 表1 where [日期] between #" & date1 & "# and #" & date2 "#"
select * from 表1 where [日期] between '#" & date1 & "#' and '#" & date2 "#'
access数据库为: "select * from 表1 where [日期] between '" & date1 & "' and '" & date2 &"'"sql数据库为: "select * from 表1 where [日期] between # " & date1 & " # and # " & date2 & " #"
'刚才写反了SQL数据库为: "select * from 表1 where [日期] between '" & date1 & "' and '" & date2 &"'"access数据库为: "select * from 表1 where [日期] between # " & date1 & " # and # " & date2 & " #"
有时候需要加 date1 & "00:00:00" "select * from 表1 where [日期] between '" & date1 & "00:00:00" & "' and '" & date2 & "23:59:59" &"'"
"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 "'" 这样就可以吧! 我就是这样 弄得
"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 "'"
"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 &"'"sql数据库为:
"select * from 表1 where [日期] between # " & date1 & " # and # " & date2 & " #"
"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 &"'"access数据库为:
"select * from 表1 where [日期] between # " & date1 & " # and # " & date2 & " #"
"select * from 表1 where [日期] between '" & date1 & "00:00:00" & "' and '" & date2 & "23:59:59" &"'"
这样就可以吧!
我就是这样 弄得