Excel Function PercentRank in MS Access ?

[world33]

1) How can I use the Excel Function PercentRank in a MS Access module? What code should I use? I have already set the MS Excel functions as an Access object.

2) How can I call that function in a Query field? What code should I use?

Please note that I am a beginner. A step by step approach would be highly appreciated.

Thank you very much for your help.

FF

[matthewspatrick]

What are you trying to accomplish? Chances are it can be done without trying to use functions from Excel...