IIF - not working

[fbacchus]

I am trying to construct an IIF statement that checks if the Location Name is null then use the district name, but if the district name is null use the location code instead. I have created :

FULLLOCATION: IIf(IsNull([Location Name], [District_Name], IIf(IsNull ([District_Name], [Location_Code],Unk));

I am getting an error on this.

Any help would be appreciated

fb

 

[ZmrAbdulla]

Location: IIf(Trim([LocationName])<>"",[LocationName],IIf(Trim([DistrictName])<>"",[DistrictName],IIf(Trim([LocationCode])<>"",[LocationCode],"UNKNOWN")))

change the field names to exactly to yours

________________________________________________________
Zameer Abdulla
Help to find Missing people
Even a thief takes ten years to learn his trade.

 

[Golom]

Check parentheses

FULLLOCATION: IIf(IsNull([Location Name]) AND IsNull([District_Name], Unk,  
IIf(IsNull ([District_Name]), [Location_Code],[District_Name]));

 

[PHV]

And this ?
FULLLOCATION: Nz([Location Name], Nz([District_Name], [Location_Code]));

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886