how to do 75th percentile for a query field

[vicki58]

hi all,

I have prod and price column
Prod has values like test1, test1,test1,test2,test2,test2 , price has pricing info 45,56,55,66,77,69, want find the 75th percentile for price column, but should be grouped by prod like test1, test2 and its 75th percentile, how do we achieve this?

Thanks for any info

[ssanfu]

Here are two places that might help you:

http://access.mvps.org/access/queries/qry0019.htm

http://www.fabalou.com/Access/Modules/percentile.asp

[vicki58]

Actually I am using the first link's procedure in my module, it calculates the percentage for the Price field, but not sure how to group it by Prod and calculate the percentage for Price field, thanks for any tips..

[funkykizzy]

I am having the same problem and I've noticed that others are too in other forums and no one seems to have come up with the solution yet.

Does anyone know how to apply this module/function to GROUPED data??

Thanks!