SQL语句insert into pp(H,S) select H,avg(A) as S from ct group by H，如何得到各组的记录个数呢？

[zcdg909]

SQL语句insert into pp(H,S) select H,avg(A) as S from ct group by H，如何得到各组的记录个数呢？

[sstlwg]

Public Function nCount(strSql As String) As Long

If strSql = "" Then GoTo EH
Call OpenDataBase
Cn.Open ...
Rs.Open ...
nCount= Rs.RecordCount
Call CloseDataBase

Exit Function
EH:

End Function

[junki]

使用Count(field)