DCount Ranking Query not working

[LDW]

I have a DCount Ranking query that worked fine last week and with this week's data came up with a glitch. Here is my DCount statement in the query:

Rank: CInt(DCount("*","qry_YTD_Territory_Totals","[Total]>=" & [Total]))

Here is my result which you can clearly see is not a tie. Any assitance is greatly appreciated...thanks!

Territory Total Rank
A 540.86 1
B 398.85 1
C 341.75 3
D 312.69 4
E 276.51 5
F 271.53 6
G 254.68 7
H 218.57 8
I 203.12 9
J 190.75 10

 

[spikepl]

I think it has to do with precision. Try
...., "[Total]>=" & ([Total] - 0.001))