title: Can someone explain the difference between "AND" and "&" in Access
body: <p>I'm pretty darn new to Access developement. Yesterday, I developed a query and in the WHERE portion, I used "&amp;" as in :</p>
  
  <pre><code>WHERE ((condition A Is Null) &amp; (condition B Is Null))
  </code></pre>
  
  <p>It returned 53 hits.</p>
  
  <p>Then I changed it to </p>
  
  <pre><code>WHERE ((condition A Is Null) AND (condition B Is Null))
  </code></pre>
  
  <p>and got 71 hits.</p>
  
  <p>I know it has to do with 'bitwise and' vs 'logical and', but can someone take a moment to explain this to me in noobish (English)?</p>