How do I sort a report on calcualted field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a report that shows the group level count and then the
details below...

Group - Count
Details of group info

However, I need to sort the list in descending order of count. How do I do
this since the count is a calculated field.
 
You can only sort/group on fields/expressions from single records, not
groups. You could create a totals query that calculates your counts. Then
add this totals query to your report's record source so you can sort/group
by the count in the report.
 
Back
Top