Count of Result

[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

 

[Douglas J. Steele]

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.

 

[RoyVidar]

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

Try adding a text control with a controlsource of

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

 

[Eric]

Thanks a lot , it helps me out

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

Try adding a text control with a controlsource of

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