Sorting Total

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

Guest

I have a report that shows just the totals by region by using a sum formula
in the region footer. Would like to sort these so the appear on the report
in descending order.
 
Supe said:
I have a report that shows just the totals by region by using a sum formula
in the region footer. Would like to sort these so the appear on the report
in descending order.
Click to expand...


Reports can only be sorted by fields in their RecordSource
table/query. They can not sort by values that are unknown
until the report has completed its processing.

You need to create a Totals type query that calculates the
region total. Then use that calculated field in the
report's Sorting and Grouping.
 
The only way to do this is to generate the totals in your query. You can
probably create a query to get the totals and join that to your current
query. Then you will be able to sort by the totals.

You can't just use the information that is generated in the report events.
 
Back
Top