Using "IF" and "OR" statements in a query...

[Luke_Murphy]

Can this be done?

I want to say that if a field equals one of 4 criteria, so If(or(x=1,x=2,x=3,x=4), THEN perform a certain calculation ELSE perform another calculation. I've got the formula in Excel...

If(or(x=1,x=2,x=3,x=4),y+z,a+b)

...but I'm not sure how to get this to work in Access

Can anyone help?

Thanks in advance!
Luke

 

[Mile-O]

=IIf(X IN(1,2,3,4),Y+Z,A+B)

 

[Luke_Murphy]

great, thanks.

 

[monbois]

In the solution formula:

=IIf(X IN(1,2,3,4),Y+Z,A+B)

What comes between X and IN ?!?

Thanks.