Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sort decending by id's total count

Status
Not open for further replies.

kastaman

IS-IT--Management
Sep 24, 2001
181
CA
I've generated a report that groups the calls by id.
In the query, I'm pasted another ID column with "count" as the total.
In the report, I have sorted by id so I can place a =sum([count of ID]) which total the calls for the id.

I'm having problem with sorting the id's according to the # of calls (Descending order). I tried sorting by count of ID but with no luck.

Can you guys help me out here. Is there a simpler way of counting/summing the calls by id then sorting in a report.

Thanks

kastaman
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top