PERCENT_RANK() IN ACCESS SQL QUERY

[ARW17]

I'm trying to find percent rank of duration (dur) per person (firstofactor) per category (worktype). I'm trying:

SELECT DUR, FIRSTOFACTOR, WORKTYPE, FIRSTOFNAME,PERCENT_RANK() OVER (PARTITION BY FIRSTOFACTOR, WORKTYPE ORDER BY DUR) AS PCTRANK
FROM [4 - EXPORT TO EXCEL];

But it says "Syntax error (missing operator) in query expression 'PERCENT_RANK() OVER (PARTITION BY FIRSTOFACTOR, WORKTYPE ORDER BY DUR)'."

Am I just missing something simple or can this not be done in SQL in Access? Thanks!

 

[Micron]

It looks to me like you're using SQL which is not exactly the same as Access sql. AFAIK, there is no "OVER" in Access. Maybe something like this will get you going in the right direction

(Ms Access) Row_Number() Over Partition

How can I convert the row_number() function with an over partition on MS ACCESS? What I want to achieve is: from this table: ID | EntryDate 10 | 2016-10-10 10 | 2016-12-10 10 | 2016-12-31 ...

stackoverflow.com