iif, iif and problems with "( )"

P

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

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])," ")
Click to expand...

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