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.

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

--
Steve Schapel, Microsoft Access MVP

B wrote:
> 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.

On Sat, 23 Dec 2006 16:45:01 -0800, B <(E-Mail Removed)>
wrote:

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

Does your version of Access have the SWITCH function?

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

"B" <(E-Mail Removed)> wrote in message
news:0244BC8B-5C7A-40C1-AD96-(E-Mail Removed)...
> 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.
>