Order by a calculated field

[belsha]

My report shows the department and number of cases it handled. No detail section is used. The number of cases is an unbound text box using the count function. Is there a way that I can sort the records so the units with the most "counted" cases show up first, from highest number of cases to lowest?

 

[KenHigg]

Could you set it up to do the count in the underlying record source?

kh

 

[belsha]

Yes, that worked perfectly! Thanks!