Total Access Statistics is the world's most popular data analysis program for Microsoft Access. It runs as an Access add-in to let you extend the numerical analysis capabilities of Microsoft Access queries.
A common need among MS Access users and developers is the need to calculate percentiles. We've created a new page providing more details on how to Calculate Percentiles in Microsoft Access with Total Access Statistics. Percentiles can be generated on the data from your table or query, and are provided in three ways:
- A new table with each percentile value as a separate field
- A new table with each percentile value as a separate record
- Updating a field in your table with the percentile value corresponding to the data in your record
Download the Total Access Statistics trial version to see for yourself on your own data.