I am using FileMaker to help organize a track and field meet. There is a record for each athlete in the Athletes Table. The record has a field called School Code. Using the School Code, I can get the full school name from the School Code Table. Each athlete's record also contains a field indicating which category the athlete is in — eg. fourth grade girl (4G), fourth grade boy (4B), etc. up to sixth grade boys (6B).
I want to create a School Statistics Report which shows how many athletes in each category for each school. I tried to create a script using various commands but so far I haven't been successful. I'm sure it is not a complicated script but due to my inexperience I'm not getting anywhere! Any suggestions on how to generate this report?
What you might be looking for is a called a sub summary report. Do a search for that. The only script needed is a sort script.