访问 25%、50%、75% 四分位数(来自查询和结果目标的数据是一份报告) [英] Access 25%, 50%, 75% Quartiles (Data From Query and Result Destination is a Report)
问题描述
我需要四分位数的数据是一个查询,第一列是月-年,第二列是该月的缺陷数.我希望在报告中显示四分位数(名称:QE Quartile Test).
The data that I need the quartiles is a query with the first column being the month-year and the second column being a count of defects for that month. I am looking to have the quartiles to be displayed on a report (Name: QE Quartile Test).
查询名称:QE 测试计数第 2 步列名:ProductionYM;索赔
Query name: QE Test Count Step 2 Columns names: ProductionYM ; Claims
以下代码是我在网上找到的,但我代码不多,所以我不知道从哪里开始.
The following code is something I found online but I don't code much so I don't know where to go from here.
Public Function XPercentile()
XPercentile = DMin(Claims, QETest, "DCount(""*"", """ & QETest & """, """ & Claims & "<="" & [" & Claims & " ]) >= " & 0.5 * DCount("*", QETest))
End Function
我知道 excel 具有执行此操作的所有功能,但我被要求让它在访问中工作.
I am aware that excel has all the functions to do this but I was requested to get this to work in access.
推荐答案
您可以在 GitHub 上找到:VBA.Quartiles
在 Microsoft Access 中以 20 种方式计算四分位数和中位数
代码在这里发布的方式太多了,但还包括一个指向完整文档的链接:
Code is way to much to post here, but included is also a link to the full documentation:
(如果您没有帐户,请浏览链接:阅读全文)
(if you don't have an account, browse for the link: Read the full article)
这篇关于访问 25%、50%、75% 四分位数(来自查询和结果目标的数据是一份报告)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!