关于SQL查询语句，我用VB+Access

[CatchFish]

rs.Source = "select shuliang,wuzibh from CaiJuLeiWuZi where wuzibh = -1166237008"没问题，可是如果


dim iBH as long
iBH=-1166237008
rs.Source = "select shuliang,wuzibh from CaiJuLeiWuZi where wuzibh = long"就不对呢？提示"No value given for one or more required parameters"

我如果改成
dim iBH as long
iBH=-1166237008
rs.Source = "select shuliang,wuzibh from CaiJuLeiWuZi where wuzibh = 'long'"还是不对？提示"标准表达式中数据类型不匹配"

我要怎么办，请高手解救！

[Virus2003]

rs.Source = "select shuliang,wuzibh from CaiJuLeiWuZi where wuzibh = '"iBH"'"

[donglw]

rs.Source = "select shuliang,wuzibh from CaiJuLeiWuZi where wuzibh = " & cstr(iBH)

[Wang_xiaoni]

donglw(天行) 正确

[s6w6k]

rs.Source = "select shuliang,wuzibh from CaiJuLeiWuZi where wuzibh = ' & iBH & '
也行

[980]

rs.Source = "select shuliang,wuzibh from CaiJuLeiWuZi where wuzibh = " & cstr(iBH)
donglw(天行) 没问题

[饮水需思源]

rs.Source = "select shuliang,wuzibh from CaiJuLeiWuZi where wuzibh = " & iBH & ""

[xysophie]

rs.Source = "select shuliang,wuzibh from CaiJuLeiWuZi where wuzibh = " & iBH

[xie7809]

rs.Source = "select shuliang,wuzibh from CaiJuLeiWuZi where wuzibh = " & iBH
也行

[watt]

"select shuliang,wuzibh from CaiJuLeiWuZi where wuzibh = "& iBH

[wxy001]

你自己看看哪里有问题，不就的了
long是什么？iBH又是什么？何必要那么多人说呢