>SELECT Courses.ctitle,Courses.tstartdate, ; > Courses.csectnum, Courses.iid,; > COUNT(students.cstatus = "PASS" ) AS nPass,; > COUNT(students.cstatus = "FAIL" ) AS nFail; > FROM regman!courses INNER JOIN regman!students ; > ON Courses.iid = Students.icourseid; > GROUP BY Courses.csectnum; > ORDER BY Courses.tstartdate >How about:
SUM(IIF(students.cstatus = "PASS",1,0)) AS nPass,; SUM(IIF(students.cstatus = "FAIL",1,0)) AS nFail,;