这句话该任何写

[whlaotou]

"select sum(胶料个数) as srkj from kj where 胶料名称＝'AA'"
上面这句话是正确的

而下面为什么就不正确呢？该任何写呢？
"select sum(胶料个数) as srkj from kj where 胶料名称='Text1.Text'"


胶料名称是字符串，而不是数字，请大家指点！！！

[白发程序猿]

"select sum(胶料个数) as srkj from kj where 胶料名称='" & Text1.Text & "'"

[k300cfree]

text1.text是变量，故先写出前面(红色段)，&为连接符，先连个变量，再连一个单引号（与前面的单引号对应）
"select sum(胶料个数) as srkj from kj where 胶料名='" & Text1.Text & "'"

[whlaotou]

谢谢二位的帮助！！！谢谢！！！

[meiZiNick]

lz要干嘛？