IIF Statement based on 2 criteria

[Aleisha Mollen]

Hello, I am working on a sales bonus database and designing the form. I have
it broken down by quarter (4) and rating (Below Threshold, Threshold, Target,
Excellence and Excellence+).

I am having trouble with the IIF function. I need the expression to say that
if the Quarter 1 radial button=yes AND the Below Threshold radial button=yes,
"0" is returned. If Quarter 1=yes and Threshold=yes, another field's value is
returned*.5, and so on and so on. The string seems to be too long to do it
all in one field, so I can do separate fields for each rating option, but the
2 IIF criterias are getting me. Please advise. I appreciate it.

Aleisha

 

[Ofer Cohen]

Try

IIF( [Quarter 1 radial button]=yes AND [Below Threshold radial button]=yes,
0 , IIf ([Quarter 1]=yes and [Threshold]=yes, [field name] *.5 ,
[AnotherValue]))

You need to replace the [AnotherValue] with the value you want if the
"[Quarter 1]=yes and [Threshold]=yes" criteria return False

 

[Aleisha Mollen]

I'll try that. Thanks. I was also noticing that when I go into the form and
click on the option button and save and close, the option button doesn't save
the next time I open the form. Any ideas on why this might be happening?

Try

IIF( [Quarter 1 radial button]=yes AND [Below Threshold radial button]=yes,
0 , IIf ([Quarter 1]=yes and [Threshold]=yes, [field name] *.5 ,
[AnotherValue]))

You need to replace the [AnotherValue] with the value you want if the
"[Quarter 1]=yes and [Threshold]=yes" criteria return False

--
Good Luck
BS"D

Hello, I am working on a sales bonus database and designing the form. I have
it broken down by quarter (4) and rating (Below Threshold, Threshold, Target,
Excellence and Excellence+).

I am having trouble with the IIF function. I need the expression to say that
if the Quarter 1 radial button=yes AND the Below Threshold radial button=yes,
"0" is returned. If Quarter 1=yes and Threshold=yes, another field's value is
returned*.5, and so on and so on. The string seems to be too long to do it
all in one field, so I can do separate fields for each rating option, but the
2 IIF criterias are getting me. Please advise. I appreciate it.

Aleisha

 

[Ofer Cohen]

Does the option buttons are bound to a field in a table? Somewhere for your
selection to be saved in.

--
Good Luck
BS"D

I'll try that. Thanks. I was also noticing that when I go into the form and
click on the option button and save and close, the option button doesn't save
the next time I open the form. Any ideas on why this might be happening?

Try

IIF( [Quarter 1 radial button]=yes AND [Below Threshold radial button]=yes,
0 , IIf ([Quarter 1]=yes and [Threshold]=yes, [field name] *.5 ,
[AnotherValue]))

You need to replace the [AnotherValue] with the value you want if the
"[Quarter 1]=yes and [Threshold]=yes" criteria return False

--
Good Luck
BS"D

Hello, I am working on a sales bonus database and designing the form. I have
it broken down by quarter (4) and rating (Below Threshold, Threshold, Target,
Excellence and Excellence+).

I am having trouble with the IIF function. I need the expression to say that
if the Quarter 1 radial button=yes AND the Below Threshold radial button=yes,
"0" is returned. If Quarter 1=yes and Threshold=yes, another field's value is
returned*.5, and so on and so on. The string seems to be too long to do it
all in one field, so I can do separate fields for each rating option, but the
2 IIF criterias are getting me. Please advise. I appreciate it.

Aleisha