Need a ranking function

[fhs]

In a select query, I have a list of values, let's say production amounts, and some of them are the same amount. I need a function that will "rank" the values, that is, identify the largest - 1, then the next largest - 2, and so forth. If there are four values that are the same then each gets the same ranking. All values need to be ranked. Know what I mean? I believe this can be done as a function that I can call from the query. Thanks.

 

[WayneRyan]

fhs,

Try this link:

http://www.access-programmers.co.uk...d=216566&sortby=lastpost&sortorder=descending

Wayne