title: How to use "like" and "not like" in SQL MSAccess for the same field?
body: <p>I would like to filter all the rows that are:</p>
  
  <pre><code>field like "*AA*" and field not like "*BB*"
  </code></pre>
  
  <p>But this is returning everything instead of showing all the rows that contains <code>AA</code> and doesn't contain <code>BB</code>.</p>
  
  <p>well now it works like expected, just restarted ms access... </p>
  
  <p>Sorry for my typo... :s updated</p>