帮助使用MS Access查找中位数 [英] Help finding the Median using MS Access

问题描述

我花了最后一天在线研究如何进行访问计算中位数。


我真的希望有人可以帮我找到我需要做的事情来找到每个名字的Ovg Pts的贷款数量中位数。


我还附上了我的示例数据库，以便您可以看到我正在使用的内容。


我找到了代码，但不知道VBA我不知道它是如何工作的


任何帮助都会非常感激

I?ve spend the last day researching online how to make access calculate the Median.

I really hoping someone can help me find what I need to do to find the median Number of Loans w/Ovg Pts for each name.

I have also attached my sample database so you can see what I?m working with.

I have found code, but not know VBA I don?t know how it would work

Any help would be greatly appreciated

展开 | 选择 | Wrap | 行号

推荐答案

从我所看到的帖子中你可以得到所需的一切。中位数函数看起来相当不错（它没有处理偶数编号的记录非常好，但这只是挑剔）而且你包含的代码说明你知道如何调用它。


你的问题是什么？

From what I can see of your post you have everything you need. The Median function appears to do a pretty decent (It doesn''t handle even numbered record counts very well but that''s just being picky) and you include code that illustrates you know how to call it.

What is your question?

感谢NeoPa，你能帮助我理解粘贴VBA后我需要做什么。很快谢谢你

Thanks NeoPa, could you help my understand what I need to do after I paste the VBA. Thank you soon much

假装我不知道你在想什么，并再次解释你想要什么。


第三时间幸运。

Pretend I don''t already know what you''re thinking, and explain again what you want.

Third time lucky.

这篇关于帮助使用MS Access查找中位数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！