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
|
|||
|
|||
IIf statement to show A, B, C
I have points calculated ... if they total 100 - then I want the field to say
A ... if the points are between 88 - 99 - then I want the field to say B ... if the points are between 70 - 87 - then I want the field to say C. I am not good with IIF statements - can anyone help? |
#2
|
|||
|
|||
IIf statement to show A, B, C
IIF([Points] = 100, "A", IIF([Points] Between 88 AND 99, "B",
IIF([Points] Between 70 AND 87, "C", "F"))) -- Build a little, test a little. "Jill" wrote: I have points calculated ... if they total 100 - then I want the field to say A ... if the points are between 88 - 99 - then I want the field to say B ... if the points are between 70 - 87 - then I want the field to say C. I am not good with IIF statements - can anyone help? |
#3
|
|||
|
|||
IIf statement to show A, B, C
Karl - thank you so very much for your help. I truly appreciate it ... it
worked great!!! "KARL DEWEY" wrote: IIF([Points] = 100, "A", IIF([Points] Between 88 AND 99, "B", IIF([Points] Between 70 AND 87, "C", "F"))) -- Build a little, test a little. "Jill" wrote: I have points calculated ... if they total 100 - then I want the field to say A ... if the points are between 88 - 99 - then I want the field to say B ... if the points are between 70 - 87 - then I want the field to say C. I am not good with IIF statements - can anyone help? |
Thread Tools | |
Display Modes | |
|
|