Rusty, it makes sense that Access cannot sort the report by a total that it
has not calculated until it has finished making the report. If you wish to
sort by a total, then you must get the total into the report's RecordSource.

You may be able to use a subquery. However, that approach is often
frustrated after you get the query working, and the report complains about a
"multi-level group by". So the solution probably involved creating another
query that calculates the totals (grouped by whatever), and using that query
as an input "table" in the report's query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rusty Shackelford" wrote in message
...
what about totals?
I want a report say on customers sorted by total orders?
But what I realy want is a report that gives a percentage of errors with
subited paperwork ( I have the report I just cant sort on the percentage)
"Marshall Barton" wrote in message
news
wrote:
Can anybody help me? I have a report and I am trying to
sort my records by a calculated field.

I would like to list the records on the report by listing
those records with the highest value first in descending
order.

The field is located in the Client ID Header section of
the report (clients are currently sorted by ID in
ascending order)

How can i get the report to sort the clients by highest
value in the calculated field in descending order instead
of client ID in ascending order?


It depends on the calculation. You can use an expression in
the sorting and grouping field/expression columns. E.g.

=Price * Quantity

The expression must refer to fields in the report's reord
source, it can not refer to controls on the report.

--
Marsh
MVP [MS Access]