MikeAngelastro
Programmer
Hi,<br>I would like to include a rank field in a query that sorts descending. I believe the row number would be equal to the rank. For instance, in a query listing in descending order of revenue generated the top 10 sales people, the sales person at the top of the list would be ranked 1, the next would be ranked 2, etc. Does anyone know how to create a field that would include the row number to be used as the rank? The result could be used on a form. <br><br>I know how to get the same result in a report by creating a text box equal to 1 and making it a running sum overall. But is there any way to do this in a query?<br><br> Thanks,<br> Mike