Casey Crookston asked about a misbehaving query: Hi Casey, I'm not 100% sure, but I'm thinking it could be an 'order of precedence' issue. Whenever I mix 'and's and 'or's I throw in enough parenthesis to make sure there is no ambiguity. HTH, RonL.