VB access数据库查询问题
我要查询wafer表中wafer字段为707I25的数据,现在的问题是

Myset.Open "select * from wafer where wafer = '707I25 ' Order by UID ASC "

上面的情况下可以查询

但是 我是把707I25赋给变量text1.text
Myset.Open "select * from wafer where wafer = 'text1.text ' Order by UID ASC "
就无法找到,

不知道什么什么,是我的写的不正确吗?

[解决办法]
"select * from wafer where wafer = ' "& text1.text & " ' Order by UID ASC "

[解决办法]
字符型变量引用： ' "& 变量名 & " '
数值型变量引用： "& 变量名 & "