Rank problem

mwb

New member
Local time
Today, 09:08
Joined
Sep 19, 2004
Messages
9
Hello!
I'm rather new in access but I have mange to do a result database, but now I have a problem.
I need to do some ranking in a special way and I think I must do it via VBA.
Is there anyone who can help me? I'm totally lost in VBA.
At least I hope you can give me some hints or solve part of the problem.
I have tried to explain what I want to have in the attachment or int he text below.

Rules for ranking
1. When a startno have got at least 3 judges (majority) when counting they should got a rank
2. If two startno have majority in the same counting-column, the startno with highest count will be placed first
3. If they have the same count the startno with the lowest sum of the three lowest judges will be first and an x set into the used columns.
4. If point three is equal the value of the lowest 4 will be and if this sum is the same use the all 5 sum
5. If you can’t split them they will get the same rank.
6. It is good if you can set a x for what sum you have used to split them


Judge Counting Plac
Startno A B C D E 1 1-2 1-3 1-4 1-5
101 1 2 1 4 4 2 3 -- -- -- 2
102 2 3 2 3 2 0 3 -- -- -- 3
103 3 1 3 1 1 3 -- -- -- -- 1
104 4 4 4 2 3 0 1 2 5 -- 4

Sums
Startno Lowest 3 Lowest 4 All 5
101 4 8 12
102 6 9 12
103 3 6 9
104 9 13 17

Used
Startno Lowest 3 Lowest 4 All 5
101 X
102 X
103
104


Thanks in advance
 

Attachments

Impressive charts, and they do give a fairly clear picture of what you are attempting to do in the foreground. However, for anyone here to be better able to help you, you might try posting your table structure(s) as well, so that we can see specifically and exactly what you are working with.
 
Thank so far for help I have found in the different forums.
Hop you can help me with this.
Here is the tables for this. The db is far bigger, but this is the affected tables.
 

Attachments

Users who are viewing this thread

Back
Top Bottom