IIf Issues

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I need to generate 3 different results. I have tried
=(iif([e]=,"No Change") or (iif([e]>,"Increased), or (iif([e]<,
"Decreased"))))

I am kinda of new to Access in developing complicated Iif statements, can
anyone help?
 
Try this

=iif([e]=,"No Change",iif([e]>,"Increased",iif([e]<,
"Decreased")))

In the iif statement you dont use the or and then iif again, the "," mark
does it for you.
 
I have a report that I need to generate 3 different results. I have tried
=(iif([e]=,"No Change") or (iif([e]>,"Increased), or (iif([e]<,
"Decreased"))))

I am kinda of new to Access in developing complicated Iif statements, can
anyone help?


If the value must be one of the three then:
=IIf([e]=,"No Change",IIf([e]>,"Increase","Decrease"))
 
Back
Top