sql = "select * from XX where number = 123"
that's no problem
but when i using a variable,it's always treat my variable as string
for example
sql = "select * from XX where number =" & _
"'" & in_num & "'"
how to convert in_num to a number
創作者介紹
創作者 小吳 VBQA 程式設計討論 的頭像
vbqa

小吳 VBQA 程式設計討論

vbqa 發表在 痞客邦 留言(2) 人氣( 14 )