title: UPDATE query - multiple criteria for same field in MS Access
body: <p>I am new to scripting in MS Access and would like to do multiple queries in one instance. I need this query to UPDATE records based off the SET criteria. Below is what I have so far. </p>
  
  <pre><code>UPDATE Inspections SET Inspections.Surveyed_By = "TDG/DT"
  WHERE Inspections.Surveyed_By="TDG/DavidT";
  OR
  UPDATE Inspections SET Inspections.Surveyed_By = "TDG/RW"
  WHERE Inspections.Surveyed_By="TDG/RobbieW"
  </code></pre>