>Hi All,
>
>I have one table with the following fields:
>
>SCORE.DBF
>
>ID# SCORE1 SCORE2 SCORE3
>
>11111 F P P
>22222 P P P
>33333 P F P
>44444 F F P
>55555 P P P
>
>F = FAIL
>P = PASS
>
>How to get the report which shows the result like this :
>
>Scan to each record and if F(FAIL) is detected then does not
>count that record at all for the calculation of percentage.
>This means only ID# 22222 and ID# 55555 should be counted
>2 records out of 5 have passed ( all P for score1,score2,score3)
>
>and to have a second REPORT.DBF with two fields :
>
>PASS/FAIL TOTALREC
>
>2 Passes 5
>3 Fails 5
>
>and finally the report :
>
>REPORT.FRM ( SCORE REPORT )
>
>PERCENT PASSED 2/5 = 40%
>PERCENT FAIL 3/5 = 60%
>
>Any kind of source coding would be greatly appreciated ?
>
>Thanks in advance,
>Paul
Paul,
As a starter what about a little trick :)
copy to lcTempText type sdf
create cursor myDummy (ID c(IDLEN), Scores c(100)) && For 100 F/P
append from (lcTempTxt) type SDF for at('F',Scores) = 0 && Only passes
Cetin