Assigning Rank in a Query

[dbaker5204]

I have a query (qryStackRank) that I would like to assign a ranking number to based on two fields. There is a Full Matrix Rating field and if there is a tie, I would like the tie to be determined by the number in the Overall Stack Ranking field. I have been reading about using Select Count(*) but I cannot get this to work.

If more information is needed please let me know.

 

[Mark_]

Please post the SQL for the query you have already tried, this will give us a better idea what the actual error is.

 

[isladogs]

I use a function called Serialize to do ranking
Please see this link for further details: TIP How to show rank order in a query

An alternative approach for this uses a subquery ....but this can be difficult to get right
See Allen Browne's website for further details: http://allenbrowne.com/ranking.html

 

[arnelgp]

The 2 field are nymeric, right? How do you determine if there us a tie, do you have any formula?