sorting table randomly

[Kaybaj]

I’m having problems with writing codes for this:
I have this object
1st 2nd 3rd
1-10% 5 8 8
11-20% 6 9 9
21-30% 7 2 10
The issue here is that:
I have 3 people
1) If either of the 3 people scores between 1-10 then that person is 1st and scores 5, the next person falls on second with 8 etc
2) If either of the 3 people scores between 11-20 then that person is 1st and scores 6, the next person falls on second with 9 etc
I don’t know if you get my point please I need help
thanks

 

[dkinley]

I don't think I am sure .. what if 1 person falls in the first 10 percentile and the other 2 falls in the other percentiles?

Anyhow, what I think you want to search on the term 'ranking queries' to see if that guides you.

HTH,
-dK

 

[jdraw]

I’m having problems with writing codes for this:
I have this object
1st 2nd 3rd
1-10% 5 8 8
11-20% 6 9 9
21-30% 7 2 10
The issue here is that:
I have 3 people
1) If either of the 3 people scores between 1-10 then that person is 1st and scores 5, the next person falls on second with 8 etc
2) If either of the 3 people scores between 11-20 then that person is 1st and scores 6, the next person falls on second with 9 etc
I don’t know if you get my point please I need help
thanks

I'm not sure I follow your post, but suggest you go to Access Help and search for PARTITION. Look through the sample.