sql 查询两个数之间

来源：百度知道编辑：UC知道时间：2024/05/31 10:15:14

sql = "select * from db1 where sum between " & Trim(txt1.Text) & "and " & Trim(txt2.Text) & ""

就是写不对

sql = "select * from db1 where sum between " & Trim(txt1.Text) & " and " & Trim(txt2.Text)

sum 这个字段，是什么类型的啊？如果是数值型的，用下面的
sql = "select * from db1 where sum between " & Trim(txt1.Text) & " and " & Trim(txt2.Text)
and 两边要有空格

and 前后都要有空格，sum如果是字段名，要用中括号括起来,最后连接的空串没必要
sql = "select * from db1 where [sum] between " & Trim(txt1.Text) & " and " & Trim(txt2.Text)