sorting on a sum total

C

CD Tom

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
 
K

KARL DEWEY

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A03 - count in report footer gives me #Error? 0
Report Group Footer DLookUp 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to implement two shifts per day with multiple teams 0
Getting Percentages Correct 3
Total not correct in Footer 2
Group Totals and Grand Totals on each page 3
Trouble with my sorting and grouping 4

Top