IIF

  • Thread starter Thread starter Pete
  • Start date Start date
P

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
 
Watch your bracketing of your object names and try:
Example: IIF([table1].[ID]=1 Or [table1].[ID]=2, "YES", "NO")
 
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
Click to expand...


.
Click to expand...
 
Back
Top