ok i have a database that has 18 fields for which i want to count values (golf scorecards). each field contains the score one hole while each record is one round of golf for someone. i want to count the number of times each score was made on each hole. sample records:
5:6:8:3:6:4:8:4:5:6:6:6:6:3:6:6:6:7
5:5:7:3:5:6:6:3:5:6:5:7:6:3:6:6:5:6
6:5:6:4:4:5:7:3:8:7:5:6:8:4:7:6:6:6so for the above, i would want to know :
hole # 1 had 3 rounds with score of 5 and 1 round with score of 6
hole # 2 had 2 rounds with score of 6 and 2 rounds with score of 5
hole # 3 had 2 round with score of 8 (ugh!), 1 round with score of 7, and 1 round with score of 6
etc
my brain hurts from thinking about this!
Code:
5:6:8:3:6:4:8:4:5:6:6:6:6:3:6:6:6:7 5:6:8:3:6:4:8:4:5:6:6:6:6:3:6:6:6:7
5:5:7:3:5:6:6:3:5:6:5:7:6:3:6:6:5:6
6:5:6:4:4:5:7:3:8:7:5:6:8:4:7:6:6:6
hole # 1 had 3 rounds with score of 5 and 1 round with score of 6
hole # 2 had 2 rounds with score of 6 and 2 rounds with score of 5
hole # 3 had 2 round with score of 8 (ugh!), 1 round with score of 7, and 1 round with score of 6
etc
my brain hurts from thinking about this!
counting values in multiple fields