iif, iif and problems with "( )"

[pgarcia]

I have the following and it would seem to work but it doesn't. I may have the
brakets in the wrong place. Thanks for your help:

IIf(([Line_Of_Business]="IMPORT BREAKBULK",[Airbill Type]), IIf([Airbill
Type]="IMPORT MISC",[Line_Of_Business])," ")

 

[fredg]

I have the following and it would seem to work but it doesn't. I may have the
brakets in the wrong place. Thanks for your help:

IIf(([Line_Of_Business]="IMPORT BREAKBULK",[Airbill Type]), IIf([Airbill
Type]="IMPORT MISC",[Line_Of_Business])," ")

With just the choices you have indicated, give this a try (I suspect
there are more choices though).

IIf ([Line_Of_Business]="IMPORT BREAKBULK" AND [Airbill
Type]="IMPORT MISC",[Line of Business],[Airbill Type])