MS-Access RANK() function
This query simulates a RANK() function.

SELECT T1.ID, (SELECT COUNT(*) 
               FROM YOUR_TABLE T2 
               WHERE T1.ID = T2.ID AND T1.OP_ID &gt;= T2.OP_ID) AS Rank 
FROM YOUR_TABLE T1
ORDER BY ID, OP_ID


It works only if there is an unique ID field that allow to count records where:

T1.OP_ID &gt;= T2.OP_ID