I'm building a db of sports statistics (at least I'm trying to). I have a layout which shows the players' performances together for each match. I have fields which summarize the data by match or by individual player. How do I set up one field which summarizes, say, all of the Serving performances for one player without pulling all the records for that one player? Eventually I want to make a layout that shows an entire team's accumulated player performance. So instead of showing performance of players 1-12 for each game I want to show the sum performance for players 1-12 for all the games. How do I set that up?

VolleyballStats_-_2_Copy_Copy.zip

Maybe I complicated the question too much.

Let's say we're playing baseball. Bobby Smith got 3 hits in his first game, 0 hits in the second, and 3 hits in his third game. I have one record for each game where I keep track of statistics. Hits has its own field in the record. I want another field that totals his hits. What single calculation do I use to total the hits? I can get the number by making all his records appear and using the summary function, but in this case I do not want all his records to appear. I want just the total hits to appear.