>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
>

SELECT Courses.ctitle,Courses.tstartdate, ;
       Courses.csectnum, Courses.iid,;
  sum(iif(students.cstatus = "PASS",1,0)) AS nPass,;
  sum(iif(students.cstatus = "FAIL",1,0)) AS nFail,;
 FROM  regman!courses INNER JOIN regman!students ;
   ON  Courses.iid = Students.icourseid;
 GROUP BY Courses.ctitle,Courses.tstartdate, Courses.csectnum ;
 ORDER BY Courses.tstartdate

Cetin