varchar转int报语法错误

[X北辰北]

sqlbuy = "select * from goods where 进货年='&inty&' and 进货月='&intm&' and 进货日='&intd&' order by 生产厂商,总金额 desc"

[shoppo0505]

inty等变量是int类型吧? 需要用ToString()转换成string

[唐诗三百首]

拼接SQL语句的写法,

sqlbuy = "select * from goods where 进货年=" & inty & " and 进货月=" & intm & " and 进货日=" & intd & " order by 生产厂商,总金额 desc"

[道素]

应该是你最后生成的SQL语句中字符串类型的值没有用单引号括起来

sqlbuy = "select * from goods where 进货年='"&inty&"' and 进货月='"&intm&"' and 进货日='"&intd&"' order by 生产厂商,总金额 desc"