Counting within a range

[Paul]

I^m relatively new to R&R, using Windows version 10 and under the gun to produce a report that is beyond me at this point. I have a "student file" with name and ID# that links up with a "test scores" file. There can be none or many "test score" records per student. I have to "print" by student the highest test score acheived and "count" it within a scoring range for grand totals. There are several ranges.____Example:__ Student: Mary Brown__Test Scores: Record 1- score 55__ Record 2- score 30__ Record 3- score 20__ Record 4- score 10____Her records would fall within two different range totals, "0" to "10" and "20" to "55". For counting purposes she would only be counted once and that would be in the "20" to "55" range because her highest score was 55.____How would I get it to "count" only the first record for that student and ignore the other 3 test score records (for totaling purposes).__I have been successful at being able to "print" only the highest score by student, but not the counting. Any thoughts would be appreciated.

[kfleming]

Email me directly and I will send you a sample report that illustrates how you might get there.____Kathleen__R&R Support__kfleming@livewarepub.com