counting data

[rokl]

Hello, i'm using access for sport competitions and I have a problem

I have data in tabele and in querie in colums like this so now I would like to calculate places for each category. The maximum points get place 1, second max place 2, third max place 3 and so on.


This is just an exemple.

THANKS FOR HELP!!!

[John_G]

If you sort the query on Points Descending, the data will display in the proper order.

[rokl]

If you sort the query on Points Descending, the data will display in the proper order.

Thanks for answering.
I need it for every category it's own sorting. And on that sorting I would like to get places automatically. The picture is just an exemple.

[orange]

Perhaps you could give readers an overview description in plain English of the big picture of what your database is about. It is better if we have all of the pieces in context when trying to offer suggestions.

[John_G]

Apply sorting in two fields - Sort by Category Ascending, and by Points Descending.

Actually putting in the place numbers can be done, but it's not particularly easy and I've never done it, so I'll leave that to the other experts to show you.

[June7]

The place numbering could be done with RunningSum property of textbox on Report. Calculating this ranking in query or form is more complicated.