field Quotes or no quotes

[tuktuk]

hey there

here is expresiion where i know that my query should result in "Ind" records

but none appears

do i have the correct syntax for the field name "Network ID"?

thanks

here it is in it entirety

Type: IIf([EAC Detail]![Network ID] Is Null,"Ind",IIf(NetworkIDs!TYPE="National","Natl","Reg"))

 

[SydneyGeek]

Try:

Type: IIf([EAC Detail]![Network ID] Is Null OR [EAC Detail]![Network ID] ="","Ind",IIf(NetworkIDs!TYPE="National","Natl","Reg"))

Denis

 

[tuktuk]

nope that didn't work....hmmmm?

 

[SydneyGeek]

Sometimes you need to nest the options. Also, the IsNull function is useful. What about...

Type: IIf(IsNull([EAC Detail]![Network ID]),"Ind",Iif([EAC Detail]![Network ID] ="","Ind",IIf(NetworkIDs!TYPE="National","Natl","Reg")))

Denis