Two IIF statements in a text box?

[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

 

[fredg]

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

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