Sort summed totals by highest to lowest.

  • Thread starter Thread starter Robert Anthony
  • Start date Start date
R

Robert Anthony

Using the wizard the report sorts by vendor by year for $ spent. I would
like to have the vendor totals $ sort a second time to rank the vendors with
the highest $ first and proceeding to the vendor with the lowest $.

Robert Anthony
661 459-1856
(e-mail address removed)
 
In the main properties of the report under data, there is an Order by
property and an Orderbyon property. You could set Order by to field name asc
for ascending or field name desc for descending.
 
If you can calculate the total in the report, you should be able to create a
totals query to calculate the same values. Save the new totals query and then
join it to the report's record source query so you have the totals in the
report fields for sorting.
 
Back
Top