三门青蟹公的好母的好:VB中查询语句字段名不能带括号解决办法

Dim cnn As ADODB.Connection

Set cnn = New ADODB.Connection
cnn.ConnectionString = "Provider=SQLOLEDB;SERVER=27SERVER;UID=sa;PWD=ibm;DATABASE=PlusLists"

cnn.Open

Dim rst As Recordset
Set rst = New ADODB.Recordset

txtsql = "select isnull(存货表.物资编码,'') as 物资编码," & _
"存货表.存货名称 as 存货名称," & _
"isnull(存货表.规格型号,'') as 规格型号," & _
"存货表.主计量单位名称 as 计量单位," & _
"sum(结算单.结算数量(iSVQuantity)) as 采购数量," & _
"sum(结算单.暂估金额(iSVAPrice)) as 买价金额," & _
"isnull(sum(结算单.费用(iSVExpense)),'') as 运杂费," & _
"sum(结算单.结算金额(iSVPrice)) as 采购总额" & _
"from 存货表, 结算单" & _
"where 结算单.存货编号(cInvCode) = 存货表.存货编码" & _
"group by 存货表.物资编码,存货表.存货名称,存货表.规格型号,存货表.主计量单位名称"

rst.Open Trim$(txtsql), cnn, adOpenStatic, adLockOptimistic

例如：结算数量(iSVQuantity)字段括号不能识别怎么办，请教高手，感谢。
没有悬赏分，希望朋友帮忙。在线等。