Nested IIF statements

[Guest]

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

 

[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

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"))

 

[Guest]

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

Jerry

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

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"))

 

[Guest]

IIf([FieldA] = "Thry" OR [FieldB] = "x","Hello","Goodbye")