HELP!!! Nested Functions in a query (1 Viewer)

[ausmoran]

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]

Quite a lot... (just kidding).

Here's the correct syntax:

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

Suc6,

RV