Does Access have the same functions like ROW_NUMBER() and PARTITION?

[aspfun]

There is ROW_NUMBER() and PARTITION in SQL server 2008.

I can write code like

ROW_NUMBER() OVER(PARTITION BY ID ORDER BY COLOR)

Does Access have the same functions like ROW_NUMBER() and PARTITION?
Or, using code or query doing the same job?

 

[Cronk]

Access does not have such functions and neither does VBA.