1。一个例子 http://www.leyoo.com/vbgood/download/code/dbdef.zip2。"select * from Table where Date= #" & format(D1,"日期格式") & "#"
SQL SERVER: select * from table as a where a.f_time>= '" & CDate(Time1) & "' and a.f_time<='" & CDate(Time2) & "'" ACCESS: select * from table as a where a.f_time>= #" & CDate(Time1) & "# and a.f_time<=#" & CDate(Time2) & "#"
http://www.leyoo.com/vbgood/download/code/dbdef.zip2。"select * from Table where Date= #" & format(D1,"日期格式") & "#"
select * from table as a where a.f_time>= '" & CDate(Time1) & "' and a.f_time<='" & CDate(Time2) & "'"
ACCESS:
select * from table as a where a.f_time>= #" & CDate(Time1) & "# and a.f_time<=#" & CDate(Time2) & "#"
不是给你贴了一个dao的例子吗?
http://www.leyoo.com/vbgood/download/code/dbdef.zip