Over the last couple of years I've been using the <> in query builder to exclude out certain categories, unfortunately this year it doesn't seem to be working anymore.
I am using the same data, the same version of ArcMap (10.0 Service Pack 5).
Would be any obvious reason for this
Solved! Go to Solution.
=, came up with an error when I verified it.
I'm using the options from "Get unique Values" so case sensitivity doesn't apply.
It might be a matter of doing the Query the long way
Change your "Or" to an "And" and see what happens. This should give what you want. By using "And" you are telling the query you want all attributes that are not Complete or Expired.By saying "Or" it is confused on which ones to exclude.
Make sure it is setup like the following.
[field name] + operator + value and [field name] + operator + value
STATUS <> 'COMPLETED' AND STATUS <> 'EXPIRED'
Obviously I do not know what your field is called so that needs to be changed in the example.
try putting either side of your OR or AND expression in round brackets ie ( ) Also, I assume that you are selecting rather than typing while you build the expression