I know that this has been addressed and that's actually where I got the code to start with...but how to I rank a recordset w/o using duplicate ranks?

This is my code:

Rank: (SELECT COUNT(*) + 1 FROM YourQuery Q1 WHERE Q1.[apInfoDateReceived] < Q.[apInfoDateReceived] AND Q1.[apInfoTimeReceived] < Q.[apInfoTimeReceived])

when I use this query...it ranks it based on date and time, but when there are duplicate dates it will rank that date using the same rank.


08/23/03 1:20PM RANK = 1
09/03/03 2:34AM RANK = 2
09/03/03 3:35PM RANK = 2
10/20/03 1:23AM RANK = 4