title: <> (not equal) is not working in a simple access query
body: <p>I have the following query where I want to pull all active employees where their CardStatus &lt;> "Lost Card".</p>
  
  <pre><code>SELECT
      dbo_Employee.Status, 
      dbo_EmpBadgeNumbers.EmployeeID_FK, 
      dbo_EmpBadgeNumbers.CardID, 
      dbo_EmpBadgeNumbers.CardStatus 
  FROM dbo_Employee INNER JOIN dbo_EmpBadgeNumbers 
          ON dbo_Employee.EmployeeID = dbo_EmpBadgeNumbers.EmployeeID_FK 
  WHERE (((dbo_Employee.Status) = "Active") 
      AND ((dbo_EmpBadgeNumbers.CardStatus) &lt;&gt; "Lost Card")); 
  </code></pre>
  
  <p>If I replace the &lt;> "Lost Card" with "Lost Card" it works, </p>
  
  <p>If I replace the &lt;> "Lost Card" with is null it works (which gives the result I'm looking for)</p>
  
  <p>If I replace the &lt;> "Lost Card" with is not null it works.</p>
  
  <p>For whatever reason it doesn't like the "&lt;>". Yes I know I can just use the "is null" scenario to get the same result, I'm curious as to why the &lt;> is not working. If it matters the query is pulling from a linked ODBC connection to sql server.</p>