Iif statement on mail form

S

Sandi V

I'm designing a mail form for conference room reservations. The composer
checks Y/N checkboxes if they need food, beverage, laptop or projector. If
both projector and laptop are unechecked, I want the cc text box to remain
blank. Otherise, I want to populate the cc text box with my own email
address. I've tried to change the datasource to:

IIf([Projector]=0 and
[Laptop]=0,"","(e-mail address removed)")

I've experimented with all kinds of parenthetical placements and keep
getting syntax errors (missing brackets, missing parens, etc.). I hope
someone can help. Thanks. -- Sandi
 
S

Sandi V

I got it: Here's what worked: I can't see what's different than the original
other than the AND is all caps. Guess that matters.

IIf([Projector]=0 AND [Laptop]=0,"","(e-mail address removed)")

original:
IIf([Projector]=0 and [Laptop]=0,"","(e-mail address removed)")
 
Top