Access Query where multiple columns not equal

Question

I have a table that has 3 columns 03000, 03010, and 03020  each column has a quanity in it. 

What I need is to see if the 3 columns do not match, if I was just doing 2 columns I would just do Diff:[03000]<>[03010] and it will populate a 0 or -1 in that column of the query, so how do I add the third colum?

Thanks

Answer 1

The answer depends on what you actually mean by 3 columns do not match - all are different or at least 1 is different

[03000]<>[03030] and [03000]<>[03020] and [03030]<>[03020]   (all are different)

[03000]<>[03030] or [03000]<>[03020] or [03030]<>[03020]    (at least one is different)

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

Answer 2

how about:

Same: [0300] = [3010] And [3000] = [3020]