number name
3 joe
6 bill
5 charles
6 doug
9 ed
Number changes as information is input at another location. Name remains the same.


Number represents a sum total of other input, or points.

As I input the numbers in another location, the sum is put here. I want to sort the information in decending order by number linking the results to a report. I do not want to do a manual sort.

results-- leading scorer ed 9
bill 6
doug 6
charles 5, etc. until the list is finished. it may include 20 names or 15.

If I add 5 poits to bill (11) then it would resort the list automatically.