请教VB下面这个语句怎么写
select * from tabel where 日期>text1.text and 日期<text2.text在VB中如何表示 --------------------编程问答-------------------- 如果“日期”是时间类型:
"select * from tabel where 日期>#" & text1.text & "# and 日期<#" & text2.text & "#" --------------------编程问答-------------------- 用datediff语句 --------------------编程问答-------------------- sql = "select * from tabel where 日期 between '" & Text1.Text & "' and '" & Text2.Text & "'"
or
sql = "select * from tabel where 日期 between #" & Text1.Text & "# and #" & Text2.Text & "#"
--------------------编程问答-------------------- --------------------编程问答-------------------- datediff
补充:VB , 基础类