sorting

[ianto]

I have a database 2010 with Names, Team and scores. I want to sort on Team and the sum of the scores for each team, all I can get is sorting on team but cant include the sum total sorted

[ranman256]

in the report,
turn on grouping for Team,
turn on the footer for team
in the Team footer drop in the SCORE field,
then alter the CONTROL SOURCE for this to: =sum(SCORE )

[ianto]

Thanks for your help, however Iv'e done all that but i am still not able to sort on the now =sum([score])

[ranman256]

you said sort on TEAM.
you cant sort on both team & score.

maybe in the report footer,add a subform to sort on SumScore.

[ianto]

sorry for confusing you but i want to sort all the players by team and then sort by team scores

[Bulzie]

Maybe give an example of the data in your table and how that data should show on a report.