Gordon wrote:

I a using Access 2007. I have a report based on a query. In the
report I am using the inbuilt sorting & grouping feature to calculate
totals for each footer record (including percentages of the grand
total.)

This all works fine but the records are coming out in alpha order
(company names) - I want them to be sorted according to the count of
each record in descending order. Access will only let me select a
query field to do the sorting in the sorting and grouping box.


You can not sort on a value that is calculated in the
report. The count calculation you want to sort by needs to
be done in the report's record source query.

If you want help with the query, please post an explanation
of what you are calculating and the fields involved.

--
Marsh
MVP [MS Access]