How to assign a specific value to each record within a query

[Access2007_NewUser]

Hello. I created a query which contains a long list of dates in descending order. I would like to add another field to the same query that will assign a value of 0 to the top (most recent) date and subtract a value of 1 from each of the remaining dates. The query results would be: Row1: 04/22/12 | 0; Row2: 04/21/12 | -1; Row3 04/20/12 | -2; Etc. Any guidance would be greatly appreciated. Code samples would be helpful too since I am pretty new to this. Thank you.

[June7]

Could you explain why you need to do this? A negative ranking/numbering is new idea.

Review these links for info on ranking and numbering records.
http://support.microsoft.com/kb/120608
http://allenbrowne.com/ranking.html
http://forums.aspfree.com/microsoft-...ge-440477.html