Updating a table based on ranking

[Guest]

I need to take a table of records ie:

total records 70
I need to range them based on 5, 20, 50, and 20 percent and need to update
based on the number so the first 5% will be updated with a Blue and then the
next 20% but this is based on 20% of 70 is updated to RED etc. How can I
write this in VBA or queries.

 

[Brainlord Mesomorph]

I think I speak for everyone when I say,
We Don't understand This Question.

You seem to have some sort of data that you wish to group in some
manner. But I can't tell if you want to turn somthing red or blue, or
label something red or blue.

please be more specific. we'd like to help.
blm

 

[Guest]

OK I've got 10 records and that will change, I need the first 5% (5% of 10 ie
..5 which is rounded 1) to be blue and the next 10% (10% of 10 ie 1) to be
Red and the next 50% (50% of 10 ie 5) to be black. The precentages are of the
total number of records. Hope this helps.
1 - Blue
2 - Red
3 - Black
4- Black
5- Black
6- Black
7- Black
8
9
10