<div>
<div class="content wysiwyg-content">
I have a table of about 500,000 records, and I want to determine the 10th, 20th, 30th, etc. &nbsp;percentiles on several different fields. &nbsp;Is there a quick and easy way to do this in Access?<br />

</div>
</div>


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?


Calculating Percentile Ranks in MS Access 2003

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.