Getting ten records only highest sums
Posted on 2011-09-12
The attached database has a report that provides a list of codes, and the count for each by a requested date range (using 5/1/2011 thru 5/31/2011). My problem is I need to get the top ten (1) highest counts which is a sum field on the report. I need the total count, listing the highest count of record to the lowest in the ten (10) codes that are counted. Can someone help?