Calculating Percentile Ranks in MS Access 2003

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?
jrimmeleAsked:
Who is Participating?
 
Patrick MatthewsCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.