IIF

[Pete]

Hello,

I would like to enter two criteria in a IIF statement. I
don't know if this is possible.

Example: IIF([table1.ID]=1 or 2, "YES", "NO")

I cannot get this to work. It will not evaluate the 1 or 2
part of the statement. Any answers to this?

Thanks

Pete

 

[Duane Hookom]

Watch your bracketing of your object names and try:
Example: IIF([table1].[ID]=1 Or [table1].[ID]=2, "YES", "NO")

 

[Pete]

Thank you very much!

-----Original Message-----
Watch your bracketing of your object names and try:
Example: IIF([table1].[ID]=1 Or [table1].[ID] =2, "YES", "NO")

--
Duane Hookom
MS Access MVP
--

Hello,

I would like to enter two criteria in a IIF statement. I
don't know if this is possible.

Example: IIF([table1.ID]=1 or 2, "YES", "NO")

I cannot get this to work. It will not evaluate the 1 or 2
part of the statement. Any answers to this?

Thanks

Pete

.