百分位用法

本文介绍了百分位用法的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

ADezii， i一直在阅读你对这个百分位问题的解决方案，相信你可以帮助我。 我有类似的问题在访问权限2007中创建百分位数。 我的表名为TBL_DATA并且我希望获得百分位数的所有值的字段称为DAYS i想要开发一个显示以下列的查询 - 最低纪元 - 最多天数 - 平均天数 - 百分位数95th - Percentile 75th - Percentile 50th - Percentile 25th i在设计视图中创建了前3列，但是我遇到了问题百分位计算。 我想访问DAYS下的所有值。并带回所要求的百分位数。 我很高兴使用VBA脚本或SQL语句，只要它得到正确的答案。 希望你能提供帮助，提前感谢你。

ADezii, i have been reading your solution to this percentile problem and believe you can help me. I have a similar problem with creating a percentile in access 2007. My table is called "TBL_DATA" and the field with all the values i would like to gain a percentile for is called "DAYS" i want to develop a query which shows the following columns - Min Days - Max days - Avg Days - Percentile 95th - Percentile 75th - Percentile 50th - Percentile 25th i have created the first 3 columns in design view however am having problems creating the percentile calculations. I would like access to look at all values under "DAYS" and bring back the percentile requested. I am happyusing either a VBA script or a SQL statement as long as it gets the right answer. Hope you can help, Thanking you in advance.

推荐答案

@SachinPatel @SachinPatel

将以下公共函数复制并粘贴到标准代码模块：

Copy and Paste the following ''Public'' Function to a Standard Code Module: 展开 | 选择 | Wrap | 行号

ADezil， 很抱歉打扰你，但是当我尝试时，你已经说过了运行查询我得到如下错误信息： 未定义函数''fCalculatePercentiles''在表达式中 有某种方式我应该保存VBA代码以确保查询可以引用它吗？ ADezil, sorry to bother you buti have doneas you stated above however when i try run the query i am getting the error message as follows: Undefined Function ''fCalculatePercentiles'' in expression is there a certain way i shouldbe saving the VBA code to ensure the query can refer to it?

@SachinPatel 如前文第30条第1项所述，必须在标准代码模块中将其定义为公共。