title: Update query with SQL
body: <p>could someone please have a quick look at the query i am writing below. A synopsis of what this query is suppose to be doing is to put the two characters "xx" in the field "Query04priorityselect" for all records where priority = "high".   It seems that all is working other than the second to last line.  The error message I get is "syntax error, missing operator" upon executing the query. 
  Thanks,</p>
  
  <pre><code>Private Sub Opzione61_GotFocus()
  
  ' identifies table to be updated
  Dim Recordset
      Set Recordset = CurrentDb.OpenRecordset("tblsearchengine01")
  
  ' puts a 1 value in the field Query04PrioritySelect for all records
  Dim ClearPriority
      ClearPriority = "UPDATE tblsearchengine01 SET Query04priorityselect=1"
  
  ' Run the command. / perform the update
      CurrentDb.Execute ClearPriority
  
  Dim HighPriority
      HighPriority = "UPDATE tblsearchengine01 SET Query04priorityselect = ""xx"" &amp; WHERE Priority&lt;&gt;high"
      CurrentDb.Execute HighPriority
  
  End Sub
  </code></pre>