var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Ranking records
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