If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditonal Format on a Field based on Percentage value
I have a field [x_wrong] on a form that has a numerical value. The number can
fluctuate wildly, so I need to base the colour change on a percentage instead of a fixed value or range. Does anyone know how to do this? |
#2
|
|||
|
|||
Conditonal Format on a Field based on Percentage value
"efandango" wrote
I have a field [x_wrong] on a form that has a numerical value. The number can fluctuate wildly, so I need to base the colour change on a percentage instead of a fixed value or range. Does anyone know how to do this? A percentage of _what_? Larry Linson Microsoft Access MVP |
#3
|
|||
|
|||
Conditonal Format on a Field based on Percentage value
Duh!, sorry Larry. It was late when I posted this message and I forgot the
important bit... In my table, i have a list of numbers representing the amount of times a user has got a question wrong, based on the field [x_wrong]. for example: [Qstn_ID] [Xrwong] [Question] Colour 4 15 blah, blah Green 6 9 " Green 18 27 " Red 4 43 " Red 9 4 " Blue 2 8 " Green 33 3 " Blue 9 3 " Blue 84 22 “ Red I want to be able to colour code the 3 ranges available, based on the highest 3rd, middle third, and lowest 3rd percentages of the values using the fluctuating highest value, and lowest value as the index. Because the values are constantly changing, i cannot use a fixed figure; say 33 because the highest value may never reach 33. "Larry Linson" wrote: "efandango" wrote I have a field [x_wrong] on a form that has a numerical value. The number can fluctuate wildly, so I need to base the colour change on a percentage instead of a fixed value or range. Does anyone know how to do this? A percentage of _what_? Larry Linson Microsoft Access MVP |
#4
|
|||
|
|||
Conditonal Format on a Field based on Percentage value
Can anyone help with this?...
"efandango" wrote: In my Form/table, i have a list of numbers representing the amount of times a user has got a question wrong, based on the field [x_wrong]. for example: [Qstn_ID] [Xrwong] [Question] Colour 4 15 blah, blah Green 6 9 " Green 18 27 " Red 4 43 " Red 9 4 " Blue 2 8 " Green 33 3 " Blue 9 3 " Blue 84 22 “ Red I want to be able to colour code the 3 ranges available, based on the highest 3rd, middle third, and lowest 3rd percentages of the values using the fluctuating highest value, and lowest value as the index. Because the values are constantly changing, i cannot use a fixed figure; say 33 because the highest value may never reach 33. "Larry Linson" wrote: "efandango" wrote I have a field [x_wrong] on a form that has a numerical value. The number can fluctuate wildly, so I need to base the colour change on a percentage instead of a fixed value or range. Does anyone know how to do this? A percentage of _what_? Larry Linson Microsoft Access MVP |
#5
|
|||
|
|||
Conditonal Format on a Field based on Percentage value
I am affraid we still cannot see what you are calculating the percentage on. for instance, why is the first one green? 15 is being divided by what to derive what percentage? [Qstn_ID] [Xrwong] [Question] Colour 4 15 blah, blah Green 6 9 " Green 18 27 " Red 4 43 " Red 9 4 " Blue 2 8 " Green 33 3 " Blue 9 3 " Blue 84 22 " Red Ron |
#6
|
|||
|
|||
Conditonal Format on a Field based on Percentage value
Thanks Ron, I have now seen the light you and Larry have been trying to shine
down my tunnel of vision... I had mental 'fix' on 3 sets of figures, Low, Med, and High (constantly changing, constantly growing), and I was expecting 'Conditional Format' to do the maths, without a common demonitator!... I have since resolved the problem, using just a Low and High box and getting 'Conditional Format' to do some logic on those two figures, with the constantly adjusting 'middle' being left as the Default Condition. It worked a treat. I now have a continous form 'column' seperating into 3 colour bands representing the Low, Mid, and High values. "Ron2006" wrote: I am affraid we still cannot see what you are calculating the percentage on. for instance, why is the first one green? 15 is being divided by what to derive what percentage? [Qstn_ID] [Xrwong] [Question] Colour 4 15 blah, blah Green 6 9 " Green 18 27 " Red 4 43 " Red 9 4 " Blue 2 8 " Green 33 3 " Blue 9 3 " Blue 84 22 " Red Ron |
#7
|
|||
|
|||
Conditonal Format on a Field based on Percentage value
We are both glad that the light popped on.
When I was teaching, I always operated on the theory that my job was to phrase the information in some manner that would connect with the student. If the student didn't understand it then I had to say it some other way so he/she could make the connection. Repeating the same information the say way would probably not get either of us anywhere (even if it was perfectly clear to me.) Have a great day. Ron |
Thread Tools | |
Display Modes | |
|
|