calculate percentile in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2003
I have a list of students and their scores on a test. I want to have a
column in a query that calculates their percent rank as compared to other
respondents. This would be a floating eprcentile as new respondents are
added.
In Excel, I used "PercentRank", but am unable to duplicate this in Access.
 
Hi,


Take a look at http://www.mvps.org/access/queries/qry0019.htm. The code
there assumes you have no null and that the decimal delimiter is the dot. If
you use a coma as decimal delimiter, uses:

... & Int(X*DCount("*", TName)))

instead of the proposed

... & X*DCount("*", TName))



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top