If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IIF Statement Help
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 |
Thread Tools | |
Display Modes | |
|
|