iif, iif and problems with "( )"

[Guest]

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])

 

[Wolfgang Kais]

Hello "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])," ")

Did you mean this:
IIf([Line_Of_Business]="IMPORT BREAKBULK",[Airbill Type],
IIf([Airbill Type]="IMPORT MISC",[Line_Of_Business]," ")) ?