[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Calculating Percentile Ranks in MS Access 2003

Posted on 2006-05-30
1
Medium Priority
?
403 Views
Last Modified: 2012-05-05
I have a table of about 500,000 records, and I want to determine the 10th, 20th, 30th, etc.  percentiles on several different fields.  Is there a quick and easy way to do this in Access?
0
Comment
Question by:jrimmele
1 Comment
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 16789766
Hi jrimmele,

The following query gets the 10th %ile.  To use a different percentile, udpate accordingly.

SELECT Max(s.SomeField) AS 10thPercentile
FROM
    (SELECT TOP 10 PERCENT SomeField
    FROM SomeTable AS s
    ORDER BY s.SomeField) AS s

Regards,

Patrick
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question