On 15 apr, 17:06, cathyt wrote:
I’m looking to write an IIF statement to use as the control source for the
ATTDATE2 field. *I have a form called GeneralForm with a subform on it called
HistoryForm.

My goal is to have:
=IIF([SIGNWORK]=”Install” OR “Replace” OR “Relocate & Replace” AND
[FACETYPE]=”High Intensity” OR “Diam. Grade”,[COMPDATE]+7305)

Signwork and Facetype are both combo boxes. *I’ve tried nesting IIF and it
will work (see below), but when I try a third string, I get an error message
about the wrong number of arguments. *Plus, it’s complex and I’m sure there’s
a better way to do this. *

Tried and works like this only:
=IIf([SIGNWORK]="INSTALL" And [FACETYPE]="DIAM. GRADE",[COMPDATE]+7305,
IIf([SIGNWORK]="REPLACE" And [FACETYPE]="HIGH INTENSITY",[COMPDATE]+7305))

Any suggestions would be appreciated.
Thanks!
Cathy

Try:

=IIF(([SIGNWORK]=”Install” OR [SIGNWORK]=“Replace” OR
[SIGNWORK]=“Relocate & Replace”) AND ([FACETYPE]=”High Intensity” OR
[FACETYPE]=“Diam. Grade”),[COMPDATE]+7305)


Groeten,

Peter
http://access.xps350.com