title: How to pull (null) records in Access database
body: <p>I would like to pull some records in an access database query where the the condition of the column is (null). Here is the sample records:</p>
  
  <pre><code>Drink column:
  (null)
  Pepsi
  Tea
  (null)
  Ice Tea
  (null)
  </code></pre>
  
  <p>I would like to pull those records that have the (null) values. Here are my queries so far but it did not return the desired result.</p>
  
  <pre><code>SELECT PRODUCT.DRINK
  FROM PRODUCT
  WHERE (((PRODUCT.DRINK) Is Null));
  
  
  
  SELECT PRODUCT.DRINK
  FROM PRODUCT
  WHERE (((PRODUCT.DRINK)=(Null)));
  </code></pre>
  
  <p>My desired result is:</p>
  
  <pre><code>Drink:
  (null)
  (null)
  (null)
  </code></pre>
  
  <p>Thanks very much for your help!</p>