Information générale
Catégorie:
Codage, syntaxe et commandes
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement