HELP with IIF function

[lpfluger]

Hi everyone, Im trying to run an update query based on the next IIf function:

IIf([Proc]![Value]=1,0,(IIf([Proc]![Value]>1 & [Proc]![Value]=<15,1,(IIf([Proc]![Value]>15 & [Proc]![Value]=<30,2,Null)))))

But the problem is that only works for the first condition, that is, [Proc]![Value]=1. The rest of the records are updated to 1, including those that should be 2 or Null.



Can someone tell me what I'm doing wrong please?

[pbaldy]

You want to separate tests with AND rather than &. & is a concatenation operator.

[lpfluger]

You want to separate tests with AND rather than &. & is a concatenation operator.

Yes!!!! now it works perfectly.
I'm going to make you a monument pbaldy

Thanks !!!

[pbaldy]

LOL! Happy to help.