Sorting on the count in a report

[bradx]

I have created a report that groups and counts our patient list by zip code. My boss is wanting the top 10 zip codes of our patient list. Is there any way that I can sort based on the group footer expression =count([zip])? Or is there a better way to get this information?

Your help would be greatly appreciated.

Brad Thibodaux

 

[Golom]

Generally it's

Select Top 10 ZipCode, Count(*) As CountOfZipCodes
From tbl
Order By 2

 

[Golom]

Sorry 'bout that ... forgot the group

Select Top 10 ZipCode, Count(*) As CountOfZipCodes
From tbl
Group By ZipCode
Order By 2

[/color

 

[bradx]

I apologize for my ignorance, but where would I enter this code?

Brad