title: Update query is modifying all the records
body: <p>I have an update query which will compare fields in two tables and if the field's are different move over the new field (table2) into table 1. Then update the 'New', 'Changed', 'Preexisting' fields in table 2 to true. But what happens is it's marking all the changed, and preexisting fields to true. It does copy the changed data into table 1, but for some reason it's marking all records imported to true.</p>
  <p>SQL</p>
  <pre><code>UPDATE [NAVAIR Deficiencies] INNER JOIN NAVAIR_Deficiencies_Temp 
  ON [NAVAIR Deficiencies].[Unique Deficiency Code] = NAVAIR_Deficiencies_Temp.[Unique Deficiency Code] 
  SET [NAVAIR Deficiencies].[Hull Q] = [NAVAIR_Deficiencies_Temp]![Hull Q],
      NAVAIR_Deficiencies_Temp.Changed = True, 
      NAVAIR_Deficiencies_Temp.Preexisting = True
  WHERE ((([NAVAIR Deficiencies]![Hull Q])&lt;&gt;[NAVAIR_Deficiencies_Temp]![Hull Q])) 
     OR (((Nz([NAVAIR Deficiencies]![Hull Q]))&lt;&gt;[NAVAIR_Deficiencies_Temp]![Hull Q]));
  </code></pre>