Rank Against My Standard Deviation that Looks Like this 0.125 Please Help

[TBC]

I’m trying to rank against my standard deviation which looks like this
standard deviation: 0.125
The formula I’m using is this:

 SDRank: 1+DCount("*","[Tablename]","[ standard_deviation]<" & [standard_deviation]) 
but the only number that comes back is “1” I have over a hundered reps that I’m trying to rank using their standard_deviation. Is there something I need to change in my formula to calculate a number below 1, such as the standard_deviation “0.125” 
Thanks for taking the time to help.

 

[John Big Booty]

Perhaps the sample posted here will give you some pointers.

 

[vbaInet]

TBC: You've been warned before on a different thread about double posting and you're still continuing in this fashion. If you don't take heed, you will be reported to the forum Admins which may lead to an official warning followed by a ban (if you don't adhere to instructions).

Your original thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=203997

 

[John Big Booty]

TBC: You've been warned before on a different thread about double posting and you're still continuing in this fashion. If you don't take heed, you will be reported to the forum Admins which may lead to an official warning followed by a ban (if you don't adhere to instructions).

Your original thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=203997

 

[TBC]

sorry. wont happend again

 

[vbaInet]

I guess we could continue on this thread.

Can we please see your db?