Im hoping someone can help me with my newest rank issue.
Im trying to get a rank my standard deviation so it will be a number below 1, the numbers I'm trying to rank are below.

Example:
Code:
Rank1: 1+DCount("*","[Table1]","[Standers deviation]<" & [Standers deviation])

What happends when I run the formula above all my ranks comeout to "1"

[quote]
-0.346475955413238
-0.393008929311432
-0.313430681489258
0
-0.408248290463863
-0.39972826427894
-0.379339734056029
-0.123600171413157
-0.365864893089862
-0.183973875868388
-0.371230105706986
-0.262369301094045
-0.321886521586874
-0.391106441996541
-0.137470711646278
-0.124342264640857
-0.228627545996961
-0.314589973831583
-0.217890019842972
-0.271519018007927
-0.251561710306367
-0.249946076975505
-0.269279732015007
[quote/]


Thanks for all your help