IFF OR Statement

[tennisbuck]

Hello,


How do you write a iff/OR statement in access? For example:

· In the bucket, check if the L5,L6 and L7 taxonomy codes match. ** If the field is null it is ok. Throw out exceptions with a status “codes mismatch”

o [e.g. Mfg name mfg Num L5 L6 l7

§ Ford 100 2000 3000 4000

§ Ford 100 2000 - -



So basically columns L5, L6, L7 have to equal each other or be NULL. If it doesn't meet this condition it would be false.



This example would be true.

[June7]

Will L5 always have value?

Try:

IIf(L5=Nz(L6,L5) AND L5=Nz(L7,L5), "Equal", Null)

[tennisbuck]

Actually L5 might be zero also.

So here how it would need to work

So these are the values L5, L6 and L7

1000, 1000, 1000

1000, null, 1000
null, 1000, 1000
null, null, 1000


1000, 1000, null.

Everything else false that says code mismatch

[June7]

You mean it might be Null?

Try this:

SELECT *
FROM tablename
WHERE (((IIf(Nz([L5],Nz([L6],Nz([L7],1)))=Nz([L6],Nz([L5],Nz([L7],1))) And Nz([L5],Nz([L6],Nz([L7],1)))=Nz([L7],Nz([L5],Nz([L6],1))), "Equal", Null)) = "Equal"));