title: How to select and display row of an empty value in MS Access?
body: <p>I have a table with 2 columns, let's say that it is Column1 and Column2. In Column 1 there is one row that has no value while in Column2 all rows have a value.
  Here's an example:</p>
  
  <pre><code>Column1 | Column2
  -----------------
     A    |    1 
     B    |    2 
          |    3 
     D    |    4 
     E    |    5 
  </code></pre>
  
  <p>I want to display the names of Rows in Column1 whose value = null or "".</p>
  
  <p>Here's my code</p>
  
  <pre><code>SELECT Column1, Column2
  FROM table_Sample
  WHERE Column1 = NULL;
  </code></pre>
  
  <p>but it is wrong.</p>