I want a list of courses with the number of students who pass and fail each one. The following is what I am working with, but am having no luck getting correct numbers for the nPass and nFail vars. Would anyone have a suggestion?

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