AnsweredAssumed Answered

Summary on a summary

Question asked by tomo17 on Sep 6, 2011
Latest reply on Sep 12, 2011 by tomo17

Title

Summary on a summary

Post

I have a database that has statistics for players in a league for each game played.  I have a summary field that calculates the number of games that a player has played by counting the number of entries for each name and this is displayed on a player info layout.

What i am trying to do is a report that generates the number of games that are played by players from each year of birth. ie 1992 =34, 1993 = 48 etc

The report script sorts by club and year of birth ok however the games played is not accurately being generated.The number that is being shown is just the number for the FIRST record found for each year or birth.

How can i get it to calculate the total number of games by age group.

 

Thanks

Outcomes