IN and IIF functions

[Guest]

How do I use the IN and IIF functions together? I am trying to have the
expression look into a particular field and find certain items and return a
description if ithe item is found.

 

[Steve Schapel]

B,

I think I would prefer to do it like this...
IIf([Particular Field]="Certain Item 1" Or [Particular Field]="Certain
Item 1","a description","nothing")

 

[John Vinson]

How do I use the IN and IIF functions together? I am trying to have the
expression look into a particular field and find certain items and return a
description if ithe item is found.

By correctly configuring the expression to do what you want with the
data that you have.

Since we do not know what "certain items" or what "description" you
are referring to, it's more than a bit difficult to answer.

John W. Vinson[MVP]

 

[David F Cox]

Does your version of Access have the SWITCH function?

SWITCH(test1,result1, test2, result2, ....)