Summary on a summary
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.