I have a report based on a query where I've calculated percentages. I intend to rank these records based on the percentages field such that the hight percentage is first and so on. How do I go about this.
-
-
If you mean simply order from highest to lowest, that's done by the ORDERBY clause which is easily set in the query editor via the sort order; however, if you are talking about assigning a number such that the highest percentage is ranked as "Number One" the second highest as "Number Two," etc... then you need a ranking query which Rabbit explains how to accomplish in this insight article:
home > topics > microsoft access / vba > insights > ranking queries in ms access sql
Comment