I would like to get rank by using ms access

[Samuel Wekesa]

Formula for finding rank in ms access

[Nauticalgent]

Maybe you should try posting this in the Access forum of this site and not Oracle?

[Nauticalgent]

Not quite following g you here...is Rank a field in a table or are you referring to an Autonumber field? Going to need some details in order to help.

[twinnyfo]

Conceptually, you have to use the DCount() funciton on the query or table you want the rank for. However, you need to provide more information before we can give any better advice.

[jfreeland]

If you want to rank data in MS Access, you will need to go into the query builder and in SQL view.

SELECT Table,
       (SELECT COUNT(T1.fieldyouwanttorank) 
          FROM
                 [Table] AS T1 
         WHERE T1.fieldyouwanttorank>= T2.fieldyouwanttorank) AS Rank 
FROM 
      [Table] AS T2 
ORDER BY fieldyouwanttorankDESC

This YouTube video also provides a guide on how to do it (as well as how to break a tie when you have ranked data with 2 or more of the same number): https://youtu.be/9wlme8NcBC8

[cactusdata]

My function RowRank is for you:
VBA.RowNumbers# 5-rank

[isladogs]

See also my approach based on the Serialize function: Rank Order in Queries