lcode=c1,c2...........c10
sec= A to Z
result=fail/pass
fail and pass already in result( i have already replace)
Now i want all lcode with result total of fail/pass

e.g
in c1 there is 7 student fail and 20 is passed

I want c1, 20, 7
.......
Select 17
sET FILTER TO descr=thisform.descr.value.and.scode=>thisform.shiftfm.Value.and.scode=thisform.levelfm.value.and.lcode=
Count FOR alltrim(result)="Pass" To a
Count For Alltrim(result)="Fail" To f

cpass=a(for display in report)
cfail=f(for display in report)
I am using this codes