RANKING

[Gambler]

Is there an easy way to do this? I have Access 2003.
Since the Kline numbers [or any other numbers] arent ranked, I would like to rank them in a query. Then after i get them ranked i would like to be able to take their rankings and determine how many times the #1 rank wins and how many times the #2 ranks, how many times the 1 & 2 wins etc.
Hope i made myself clear.
Thanks for any help
ed

[Donnie]

Eddie-
Aren't they the same as KRank? I would think they are. Also a crosstab query could tell you how often each win....but it will also be the same number as the K win %'s.

[AwolAtHTR]

Wed 7 Mar 7

agreed Donnie, the K of the Robot (HX4 export field nK) is the KLine Rank.


Eddie,

taking your question for other values that do not have computed ranks. I create another field in my HX4 data table and use VB to prepare and post the ranks.

I think someone posted an Access Query that computed and displayed the ranks for other fields. This is the query which you could use to prepare an Update query to get the values back into your data table. I saved that out of curiousity but can't put finger on it now.

I will try to find that forum posting or maybe the postie (or is it Poster?) is still around and can repost the solution here.

[Gambler]

Thanks for all the help.
ed

[DanG]

Ed,

I searched for the thread and I can’t find it. Mike Dee showed me a VBA method to rank, but I knew so little about VBA at the time I figured out a work around.

If Mike would chime in here maybe he could recall the code or the name of the thread. My method is really not for anyone who knows VBA. I use multiple make tables, appends, updates etc…the LONG way around Access.

PS: Now that I think about it, it may have been through an e-mail from Mike. That could be why I can’t find the thread. :confused:

[MikeDee]

You can use VBA to rank (or re-rank anything) in access. Since most everyone would prefer to stay away from learning anything about VBA I don't talk about it's use.

I didn't post anything since Ed said he wanted to rank in a query. I'll be happy to share the module with anyone who wants to go down that road.

Some time ago Rick found a method on a access BB that had a ranking technique that did not involve VBA. I didn't pay a whole lot of attention to it since I am from the school of "Don't learn anything new unless you really have to":) Maybe he remembers where that thread is and can post a link to it.

If anyone is interested I can post the module and the steps necessary to use VBA for ranking factors.

[Rick]

Someone could probably find it way back in the Access and HTR2 forum.

It was something I was able to find through research and then trial and error.

Anytime I look at it I have no idea what I did.

There have been a couple of members in the past that were good at those SQL queries.

[Rick]

Try this thread:

http://www.homebased2.com/forums/showthread.php?t=3918&highlight=group