nested iif statement syntax

M

michael

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

Similar Threads

Page numbering with Merged Document and IF statements 1
Help needed with IIF in my query 14
Nested IIf stops after two conditions 8
Formula displays Error rather than message 2
Problem with IIF statement 5
Nested IIF expr not evaluating 2nd condition and beyond. 2
IIF Syntax error 4
Trying to nest IIf statements in a report 3

Top