Two IIF statements in a text box?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Is it possible to have two IIf statements in an expression?
I have 3 textboxes on my form: [BeginCertNolbl], [EndCertNolbl] and
[Count]. Here is my expression in [Count] Thanks..Randy

=IIf([BeginCertNolbl] Is Null,"0"-1,[EndCertNolbl]-[BeginCertNolbl])+1
I also need something like this in my present expression.

=IIF([EndCertNolbl] Is Null,=[BeginCertNolbl],IIf([BeginCertNolbl] Is
Null,"0"-1,[EndCertNolbl]-[BeginCertNolbl])+1
 
Is it possible to have two IIf statements in an expression?
I have 3 textboxes on my form: [BeginCertNolbl], [EndCertNolbl] and
[Count]. Here is my expression in [Count] Thanks..Randy

=IIf([BeginCertNolbl] Is Null,"0"-1,[EndCertNolbl]-[BeginCertNolbl])+1
I also need something like this in my present expression.

=IIF([EndCertNolbl] Is Null,=[BeginCertNolbl],IIf([BeginCertNolbl] Is
Null,"0"-1,[EndCertNolbl]-[BeginCertNolbl])+1
Click to expand...

The basic syntax is like this:
=IIf([SomeField] = criteria,True value,IIf([OtherField]= other
criteria,OtherTrue Value,FalseValue))
 
Back
Top