Sort by largest sub-total

[Steve via AccessMonster.com]

I need to know how to take a report that is grouped by account number showing
cost detail - it shows the account number, all detail including spending,
then at the end of the group shows the sub-total -then the spending by the
next no. and a sub-total for that acct number and so on.

How can I order the report by the account number with the largest spending
sub-total ?

 

[Duane Hookom]

Create a totals query that groups by account number and totals spending. Add
this query to your report's record source and join the account number
fields. Add the SumOfSpending field to your report so you can sort on it.

 

[Steve via AccessMonster.com]

Duane: Thanks !

Create a totals query that groups by account number and totals spending. Add
this query to your report's record source and join the account number
fields. Add the SumOfSpending field to your report so you can sort on it.

I need to know how to take a report that is grouped by account number
showing

[quoted text clipped - 4 lines]

How can I order the report by the account number with the largest spending
sub-total ?