Updating a table based on ranking

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
Back
Top