sorting on a sum total

[Guest]

I have a report built on a query, in the query there is a teamno and there
are two members in each team. I have a grouping on the teamno and am summing
up the total points in the teamno footer. I want to sort the report by the
total in the teamno footer. Is there any way to do this.

Thanks

 

[Guest]

One way would be to use a totals query to do the summing. Then group on the
Sum and then TeamNo.