Your summary field needs to be in a sub-summary section (the one for year of birth).
Thanks Sorbsbuster for your response.
I have the field ins the subsummary section which is why i am a bit confused as to why it is not working
You get the data from the first record in a set if you put a non-summary field into the sub-summary line. For example, if you sort by Team and you put the field 'Team' into the sub-summary you will see the team name. But if you put the PlayerName field in there you will see the name of the first player (although depends if you have a leading or traling summary). Are you sure it is the summary (count) field that you have used? And it is defined as a Summary?
Thanks - I have redone the calculation and it now sems to be working. I think that it was becuase i had it is a running count rather that restarting after each individual.
All good now - thanks for you help