Sort in Descending order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
As much as I know, you can't.
You can sort the report only with fields that are part of the report record
source.
 
Back
Top