Count of Result

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Dear all,

Need help.. I ve a report list out some of the examine results of the
student.

I managed to get the total participants by using count(*)

But i also want to know how many of them are "pass" and how many of them are
" failed" and how many need to arrange " re-sit".

I can not use countif [status]="pass"

how can i do it .. appreciate your help

Eric
 
Add a computed field to the query on which the form is based that returns 1
for a pass and 0 for a failure:

IIf([status] = "pass", 1, 0)

You can then sum that field to get the total passes.
 
Eric wrote in message said:
Dear all,

Need help.. I ve a report list out some of the examine results of the
student.

I managed to get the total participants by using count(*)

But i also want to know how many of them are "pass" and how many of them are
" failed" and how many need to arrange " re-sit".

I can not use countif [status]="pass"

how can i do it .. appreciate your help

Eric
Click to expand...


Try adding a text control with a controlsource of

=sum(abs([status]="pass"))
 
Back
Top