Hello all. I have some queries that rank with DCount and show ties like this - 1,2,2,4,5,5,5,8...
Is there a way to get a rank that would look like this instead?
1,2,2,3,4,4,4,5
The change would be that the numbering stays consecutive, instead of jumping to the next "number of record"...