再请各位帮忙:
rs.Open "select id,count(neirong.id) as b from neirong where title='" & .TextMatrix(.Row, 4) & "'", cn
If Not rs.BOF Then
Do Until rs.EOF
For A = 1 To rs("b")
AA(A) = rs("id")
Next
Loop
rs.MoveNext
End If
rs.Close
报错:
列'neirong,id'在选择列表中无效,因为该列未包含在聚合函数中,并且没有GROUP BY子句