Prev: Format text box as Bulleted List as default
Next: Calculated field in Forms
From: Jill on 14 Apr 2010 12:11
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?
From: KARL DEWEY on 14 Apr 2010 12:15
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?
From: Jill on 14 Apr 2010 14:06
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?
 | 
Pages: 1
Prev: Format text box as Bulleted List as default
Next: Calculated field in Forms