This may sound dumb, but I use it all the time:
If you have the total you want to sort by in the
query...rename the query to QUERYNAME1. Open a new query
and base it off of QUERYNAME1, bring in all the fields and
sort as you need, then save it as the original query
name.

When you open the report, the 2nd query calls the 1st to
run. It runs, generates the variable field you need, then
the 2nd query grabs that data, sorts it, and then feeds it
to to the report.

-----Original Message-----
Hello There,

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?

Can anybody please help

Thanks
Adam
.