nested iif statement syntax michael 28.08.2006 04:09:02 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

Re: nested iif statement syntax "Duane Hookom" <DuaneAtNoSpanHookomDotNet> 28.08.2006 04:30:44 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],"") -- Duane Hookom MS Access MVP "michael" <michael[ at ]discussions.microsoft.com> wrote in message news:3BA5656D-0FFA-4482-9B69-04DAF08BD826[ at ]microsoft.com... [Quoted Text] >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