Sort by group total

[Alex]

I have a report using a query that contains a "total"
field that is summed. My report is grouped by "customer",
showing the customer name in the group header and
the "total" in the group footer. The report is currently
sorted by ascending customer name. How can I keep my
customer group together, with totals at the end of each
group, but sort by the "total" that is in the group
footer?

Thanks for your help

 

[Steve Schapel]

Alex,

One way to do this, is to make a Totals Query, which gives you a total
per customer, such as the totals that you presently have calculated in
the grpoup footer of the report. Then, add this query to the query that
the report is currently based on, joined on the applicable customer
field. Then, this per customer total figure should be available to be
used within the report's Sorting & Grouping as the basis of the first sort.