Sorting by Summary Field in a report

[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?

 

[Duane Hookom]

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.