title: Query results not showing records with null values
body: <p>I'm designing a search form to search my access database based on 4 text fields, Firstname, Surname, Phonenumber and Promo Code.</p>
  
  <p>The queries look like:</p>
  
  <pre><code>Like "*" &amp; [Forms]![SearchF]![txtFirstName] &amp; "*"
  Like "*" &amp; [Forms]![SearchF]![txtSurnameName] &amp; "*"
  Like "*" &amp; [Forms]![SearchF]![txtPhone] &amp; "*"
  Like "*" &amp; [Forms]![SearchF]![txtPromo] &amp; "*"
  </code></pre>
  
  <p>The search should return all records if all the fields are blank. When you enter some values in the text boxes, the results are narrowed down to matches.</p>
  
  <p>It almost works fine, but problems occur when there is no value in certain fields. For instance, if someone doesn't have a promo code then their record will always be skipped over even if you leave it blank. I assume the access query doesn't like blank fields.</p>
  
  <p>What's the easiest way to get around this?</p>