|
| 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
April 14th, 2010, 05:11 PM
posted to microsoft.public.access.forms
|
|||
|
|||
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
April 14th, 2010, 05:15 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
April 14th, 2010, 07:06 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 | |
|
|
Linear Mode
