Ranking

[zachariack]

Hi friends



how to create ranking from a query
query: qryTotalPoint (Player_ID, Player_Name, Category, Total_Point)

need to make ranking for eachcategory

Thanks

[CJ_London]

With so little information provided I’m guessing all you need is a pointer in the right direction

Use an aggregate sub query to count the number of records where category = the current record category and points is less than the current record points

or slightly less efficient, use the dcount function with the same criteria

[June7]

Common topic. Review https://www.utteraccess.com/topics/2.../posts/2822588