title: Microsoft Access Cant Remove duplicates that contains Null value
body: <p>I am having trouble removing/finding duplicates when a value in a certain column contains a null value</p>
  
  <p>This was my original Criteria</p>
  
  <pre><code>    In (SELECT [PQT] FROM [Departure] As Tmp GROUP BY [PQT],[IDNUSER],[Name]
      HAVING Count(*)&gt;1  And [IDNUSER] = [Departure].[IDNUSER] And [Name] = [Departure].[Name])
  </code></pre>
  
  <p>For example, lets say Name would be the column that could contain null values,</p>
  
  <p>I tried replacing it with </p>
  
  <pre><code>And IIf(IsNull([Name]), " ", [Name]) = IIf(IsNull([Departure].[Name]), " ",
  [Departure].[Name])
  </code></pre>
  
  <p>It didn't seem to work.
  I also tried using NZ, with no success</p>
  
  <p>Here are example datas that my table would contain</p>
  
  <pre><code>**PQT**     **IDNUSER**      **Name**  
  BNC          001              Bob  
  BNC          001              Bob
  BNC          002              
  BNC          002              
  </code></pre>
  
  <p>Results of my current query
  The 2 first data with the IDNUSER 001 is considered as a duplicate since all fields have values.
  but IDNUSER 002 would not be considered as a duplicate since the value in Name is null.
  I would like my query to find all duplicates.                  </p>