How do I calculate percentile in acccess?

  • Thread starter Thread starter Guest
  • Start date Start date
More details please.

If you have two fields in a record (total sale price, discount amount) then
you would use simple math to calculate. If you want to know what percentage
a value is of the totals for that value in a table, then you have to do it
in queries or reports.

Rick B
 
To clarify, I would like to rank a group of agents based on a certain metric,
and then calculate the percentile to compare their relative performance. I
can already generate a rank for each of the agents, but just having trouble
getting the max rank, so I can have rank 12 out of 123.

Any ideas?
 
Back
Top