Assigning Rank in a Query (1 Viewer)

D

dbaker5204

Registered User.

Local time

Yesterday, 17:57

Joined

Jan 19, 2018

Messages

20

• Jan 19, 2018

• #1

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.

 

M

Mark_

Longboard on the internet

Local time

Yesterday, 17:57

Joined

Sep 12, 2017

Messages

2,111

• Jan 19, 2018

• #2

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

 

isladogs

MVP / VIP

Local time

Today, 01:57

Joined

Jan 14, 2017

Messages

18,216

• Jan 20, 2018

• #3

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

 

Last edited: Jan 20, 2018

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 08:57

Joined

May 7, 2009

Messages

19,231

• Jan 20, 2018

• #4

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