SteveL13
asked on
How sort report by group total
I have a report written that has detail lines which I'm hiding, and that is grouped by customer. In each group footer I am summing numbers in the detail section. But now what I want to do is SORT the report results by the summed numbers in the footers in descending order.
How can I do this?
--Steve
How can I do this?
--Steve
You are going to need to modify the Recordsource for the report so that it contains that "summed" quantity as a field in the recordset.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.