Nested IIF statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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"))
 
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...
 
Back
Top