请教VB编写 between...and 语句，从某数值到某数值的查询。

来源：百度知道 编辑：UC知道 时间：2024/04/29 17:19:48
scp = "字段名between #" & comboBox1.Text & "# and #" & comboBox2.Text & "#"
为什么查询不了从comboBox1到comboBox2之间的数（为小数）？哪里不对吗？谢谢！

日期在access 里面才需要#

scp = "字段名between " & comboBox1.Text & " and " & comboBox2.Text & " "

#用在查询date型值，''用来查询字符型值，如果是数值型，那什么都不加，另外注意用trim函数
如，若字段类型是字符型，则该sql应该是：
scp = "字段名between '" & trim(comboBox1.Text) & "' and '" & trim(comboBox2.Text) & "'"

"select * from mytab where num between " & comboBox1.Text & " and " & comboBox2.Text

scp = "字段名between " & comboBox1.Text & " and " & comboBox2.Text
这样就行的

加"#"是查日期的,不是数字
scp="字段名 between " & trim(combobox1.text) & " and " & trim(combobox2.text)