Sort in Descending order

G

Graham

I have a report which totals transactions then only displays the totals in
the report. How can I sort these totals in decending value order.

Thanks
Graham
 
D

Duane Hookom

You can't without adding the totals into the report's record source query.
You can create a new totals query similar to your report's record source
only view the totals and group by whatever and total whatever. Join this
totals query to your report's record source query and use the totaled field
as your sorting expression.
 
O

Ofer

As much as I know, you can't.
You can sort the report only with fields that are part of the report record
source.
 
Top