数据类型错误

[xiangdafang]

rs1.Open "select * from li where 前零 > '" + val(Combo1.Text) + "' ", cnn, 3, , adCmdText
显示数据类型错误
可是
rs1.Open "select * from li where 前零 > 1 ", cnn, 3, , adCmdText

是正确的
怎样将combo1.text 中的数据转换？？？

[of123]

rs1.Open "select * from li where 前零 > " & val(Combo1.Text) , cnn, 3, , adCmdText

[tztz520]

rs1.Open "select * from li where 前零 > "& val(Combo1.Text) &"", cnn, 3, , adCmdText

[wingedsteed]

rs1.Open "select * from li where 前零 > " + val(Combo1.Text) + " ", cnn, 3, , adCmdText

去掉" + val(Combo1.Text) + "前面的单引号就可以了.