主题：[求助]sql where 变量

Dim txt As String = Forms("窗口1").Controls("TextBox1").value
Dim q As new QueryBuilder
q.TableName = "销量统计"
q.SelectString = "Select  第一列,sum(第二列),第四列 From {表B}Where 第一列 = '" & txt & "' Group By 第一列,第四列"
q.Build
MainTable = Tables("销量统计")