在报表中人数不能正确显示。自己做一个非报表窗口,添加【加载事件】如下:Private Sub Form_Load()Dim rst As DAO.RecordsetSet rst = CurrentDb.OpenRecordset("SELECT 表3.姓名 FROM 表3 GROUP BY 表3.姓名;")'人数Text0 = rst.RecordCount'记录数Text2 = DCount("*", "表3")End Sub
CONNT(VALUE1,VALUE2)