Using Excel's percentile function
Posted on 2004-08-13
I have a function that allows me to call Excel's percentile function. I can use it in queries and in modules as well. It's set up like this: Percentile(Array,%).
I can use it easily in Modules by building arrays of values I want certain percentile ranks for, but I'm confused as to how it might be used in Access's query builder. What would go in as the Array argument if I wanted to calculate a certain percentile rank for a collection of records?
I doubt I've provided enough information to be informative, but I'm not sure what other information to provide.
Thanks for the help.