Nested IIF statements

J

JWCrosby

I need help writing a nested IIf statement in a report. Logically, it needs
to "read":

If [FieldA]="Thry" OR [FieldB]="X" then print "Hello", else print "Goodbye"

Can someone help?

Jerry
 
F

fredg

I need help writing a nested IIf statement in a report. Logically, it needs
to "read":

If [FieldA]="Thry" OR [FieldB]="X" then print "Hello", else print "Goodbye"

Can someone help?

Jerry
Click to expand...


In an Unbound text control:
=IIf([FieldA] = "Thry" Or [FieldB] = "X","Hello","Goodbye")

This is NOT a nested IIf statement.

A nested IIF statement would read like this:
=IIf([field1]= criteria,"Do This",IIf(Field2] = Criteria,"Do That","Do
Something else"))
 
J

JWCrosby

thanks, guess I was making more of it than it was!

Jerry

fredg said:
I need help writing a nested IIf statement in a report. Logically, it needs
to "read":

If [FieldA]="Thry" OR [FieldB]="X" then print "Hello", else print "Goodbye"

Can someone help?

Jerry
Click to expand...


In an Unbound text control:
=IIf([FieldA] = "Thry" Or [FieldB] = "X","Hello","Goodbye")

This is NOT a nested IIf statement.

A nested IIF statement would read like this:
=IIf([field1]= criteria,"Do This",IIf(Field2] = Criteria,"Do That","Do
Something else"))
Click to expand...
 
Top