Expression has wrong number of Arguments - help

[gheyman]

I am getting an error message for this expression:

IIF(Isnull([Cust_Coproration]),””,IIF(IsNull([Cust_Division]) AND Isnull([Cust_Location]), [Cust_Coproration],IIF(Isnull([Cust_Division]), [Cust_Coproration]&”, “&[Cust_Location],IIF(IsNull([Cust_Location]), [Cust_Coproration]&, “&[Cust_Division],[Cust_Coproration]&”, “&[Cust_Division]&”, “&[Cust_Location]))))

I looked it over several time and do not see me error.

If you see where I made a mistake, I would appreciate the help.

Thanks

 

[gheyman]

Found it. Missing one ")"

IIF(Isnull([Cust_Coproration]),””,IIF(IsNull([Cust_Division]) AND Isnull([Cust_Location]), [Cust_Coproration],IIF(Isnull([Cust_Division]), [Cust_Coproration]&”, “&[Cust_Location],IIF(IsNull([Cust_Location]), [Cust_Coproration]&, “&[Cust_Division],[Cust_Coproration]&”, “&[Cust_Division]&”, “&[Cust_Location])))))