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