Solved: Report sort order based on a count or sum field

[lawsonbooth]

I have a report that uses a count field (=Count(*)). Which is the number of records found in a group and the report covers multiple groups. Is there a way to now get the report to order by the count field, so that the group with the highest number of records is first in the report when printed? :dunno

Lawson

[austenr]

Can you post your query?

[OBP]

Have you set "Grouping & Sorting" for that Count field?
As austenr has hinted at the Count needs to be in the Query that supplies the data to the Report.
If it is only in the report, it is too late for the report to use for grouping & sorting.

[lawsonbooth]

Austenr and OBP, Thanks to you both for answering. I am sorry it took me so long to respond. I found a report that solved my problem by using a query to first calculate my totals and then sort the report by query totals. I do not think I just explained the answer to well.

This is a great site - keep up the good work!