I've been facing a glitch recently when building a selection query with multiple clauses. When I click Apply or OK after building the query, it removes the attribute value in the last clause. Has anyone else experienced this? The work-around I found is pretty simple, just clicking Apply first and then when the attribute value is erased, I re-add it, click somewhere else in the query window, and click Apply again and this time, it usually works. However, it would be ideal to not have to do any work-around at all, as sometimes if I just hit OK I may not notice that the last clause was eliminated.
Not sure if this is something ESRI is aware of or working to fix, but it is indeed a minor inconvenience in one of my most common GIS tasks.