T
Tony Winter 77
Hello,
Hope someone can help with this. I have a table with 4 fields. I want to
rank each of these fields, then add the result of the ranking to give an
overall rank. I need to have the rank show 11,2,3,3,3,4 rather than
1,1,3,4,4,4,7 so that it is the position in the rank that counts.
I'm explaining badly, but here is an illustration:
Data 1 Data 2 Data 3 Data 4 Rank 1 Rank 2 Rank 3 Rank 4 Overall
Rank OR
Sum
1.1 .9 3 .4 1 3 1
2 7 1
1.1 .8 3.1 .4 1 2 2
2 7 1
1.2 .8 3.2 .4 2 2 3
2 9 2
1.1 1.0 3.3 .3 1 4 4
1 10 3
1.3 .5 3.1 .3 3 1 2
1 7 1
Each data set is ranked, then the rank position summed, then the sum
position Ranked. This lets me create a league weighted by multiple criteria.
I can do this in Excel just about, but in access it seems impossible. Do i
need to brake it down into 4 queries then link it back together? I want to
avoid that and do it in one, but if its impossible then its impossible.
Cheers for any advice!
Hope someone can help with this. I have a table with 4 fields. I want to
rank each of these fields, then add the result of the ranking to give an
overall rank. I need to have the rank show 11,2,3,3,3,4 rather than
1,1,3,4,4,4,7 so that it is the position in the rank that counts.
I'm explaining badly, but here is an illustration:
Data 1 Data 2 Data 3 Data 4 Rank 1 Rank 2 Rank 3 Rank 4 Overall
Rank OR
Sum
1.1 .9 3 .4 1 3 1
2 7 1
1.1 .8 3.1 .4 1 2 2
2 7 1
1.2 .8 3.2 .4 2 2 3
2 9 2
1.1 1.0 3.3 .3 1 4 4
1 10 3
1.3 .5 3.1 .3 3 1 2
1 7 1
Each data set is ranked, then the rank position summed, then the sum
position Ranked. This lets me create a league weighted by multiple criteria.
I can do this in Excel just about, but in access it seems impossible. Do i
need to brake it down into 4 queries then link it back together? I want to
avoid that and do it in one, but if its impossible then its impossible.
Cheers for any advice!