Sorting a report by count results

[James Owens]

I have a pretty simple report. I am using on table which
has a membership dump of NT groups. The report shows the
group name and counts the instances of that name and the
result is the number of members in the group. I want to
sort the resulting list by the Count expression result so
the groups with the most members are listed first. I have
drawn a blank on how to do this. Any help would be
greatly apprecieated. Thanks.

 

[Duane Hookom]

You can't sort by an aggregate (count or sum) that is derived in the report.
You would need to create a separate totals query that groups by NTGroup and
counts members. Then add this query to the record source query of your
report. This will allow you to sort by the CountOfMembers.