Access Top 10

[Beerman3436]

Does anyone know how to have a report that will place a number beside the top ten people on the list.

The list has over 50 people on it and the total number of calls they have received. What I need is for the system to look at the totals and then put a 1 beside the person with the highest total and 2 and 3 and so on.

email me please at dragon3436@hotmail.com

And thanks for any help.

 

[Carol]

You could do a sort within your report that would list the totals in ascending order. Beside each detail line within your report you could have a rank. Create a text box, listing your control source as =1. This would then follow for each additional detail line in ascending order.

 

[Beerman3436]

That did not work. I only need for the top 10 people with the most calls to have a number beside their name.