Data1.RecordSource = "select * from product where 类型 like '* " & leixing & "* ' and 型号 like '* " & changjia & "* ' and 价格 between '* " & jia1 & "* ' and ' *" & jia2 & "* '"
Data1.Refresh
Data1.Refresh
调试欢乐多
Data1.Refresh
用between后麵是數字就不用單引號~字符就有單引號!沒有%跟*這些東西的