View Full Version : HELP!!! Nested Functions in a query


ausmoran
02-14-2002, 04:06 PM
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

RV
02-14-2002, 11:39 PM
Quite a lot... (just kidding).

Here's the correct syntax:

IIF([field2],"100",IIF([field3],"102",IIF([field4],"106","")))

Suc6,

RV