sql = "select * from 户型资料表 where Hst_buildarea between【空格】" & CInt(Trim(Txtmianji1.Text)) & " and " & CInt(Trim(Txtmianji2.Text))//between 后边应该加上一个空格