Information générale
Catégorie:
Codage, syntaxe et commandes
COUNT FOR score1 = 'P' and score2 = 'P' and score3 = 'P' to somecount
pctpass = somecount/reccount()
pctfail = (reccount() - somecount)/reccount()
>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
Précédent
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