nested iif statement syntax

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

Guest

I have two y/n fields that need to trigger printing on a report. I am using
the following, but i keep getting a syntax error. If first Y/N=true the test
the next Y/N to print BadgeText4

=iif([events],=IIf([RSVP4],[BadgeText4f],""),"")

TIA for any direction,
michael
 
If Events and RSVP4 are the Y/N fields and they both have to be true in
order to print BadgeText4f then use:

=IIf([events] And [RSVP4],[BadgeText4f],"")
 
Back
Top