Validation Or not working

[JulieAHop]

Hi,

I'm trying to set some validation rules on a field, each rule works alone but when together with an Or operand both rules are not validated.

Here is what I am using..

Nz(([PIG]>[SumOfQty])) Or (([PIG]+[COQtyDes])<=[COQty])


Any ideas or pushes in the right direction would be greatly appreciated.

Many thanks

J

[andy49]

Both suggests an and operand is needed?


Sent from my iPhone using Tapatalk

[JulieAHop]

Thx for your response. I need it to validate either not both.

[aytee111]

When you say both rules need to be validated, that means you will get all data where either one or the other are true. What results are you getting that don't apply to either rule?

[andy49]

Why use nz here the first part will return true or false? So nz wouldn't apply.


Sent from my iPhone using Tapatalk

[Micron]

either will return true or false
([PIG]>[SumOfQty]) Or (([PIG]+[COQtyDes])<=[COQty])
If 6 > 5 Or 6+4<=20 evaluates to (1) OR (1) (True) OR (True)
All other combinations are, of course, possible but the outcomes are basically the same. I agree with post #2 - the operand should be AND?

If 6 > 5 AND 6+4 <= 20 (True) AND (True)
then test passes?

[JulieAHop]

Thank you all so much for your responses. It's now sorted. Your replies helped me get my head round something that in the end really was simple, I had just spent too long thinking and getting my brain cells in a tizwaz.

Your help is very much appreicated - thanks guys And Or girls