A ausmoran Registered User. Local time Today, 14:01 Joined Aug 30, 2001 Messages 13 Feb 15, 2002 #1 Can someone tell me what is wrong with the syntax here? SPEC:IIF([field2],"100","",IIF([field3],", 102","",IIF([field4],", 106",""))) Thanks in advance Austin
Can someone tell me what is wrong with the syntax here? SPEC:IIF([field2],"100","",IIF([field3],", 102","",IIF([field4],", 106",""))) Thanks in advance Austin
R RV Registered User. Local time Today, 14:01 Joined Feb 8, 2002 Messages 1,115 Feb 15, 2002 #2 Quite a lot... (just kidding). Here's the correct syntax: IIF([field2],"100",IIF([field3],"102",IIF([field4],"106",""))) Suc6, RV
Quite a lot... (just kidding). Here's the correct syntax: IIF([field2],"100",IIF([field3],"102",IIF([field4],"106",""))) Suc6, RV