Sorting by Summary Field in a report

  • Thread starter Thread starter Jim Forbes
  • Start date Start date
J

Jim Forbes

Access 2002

I have made a report which contains a Summary Field [a sum
of the turbine capacities for each project under
development] for each Turbine Manufacturer. Currently the
report sorts on the Turbine Manufacturers field in
alphabetical order. I want the report to create a
descending order sort on the Summary Field column.

When I hav attempted to sort by the Summary Field column,
Access breaks the Summary Field [de-summarizes the data]
into the individual projects.

How do I do this?
 
You should be able to sort by any field in your report's record source. You
can't sort by an aggregate calculation from a group header or footer. You
would need to create a totals query and then join this query to your
report's record source.
 
Back
Top