nested iif statement syntax

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
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top