title: Syntax error (missing operator) in query expression 'ProfID=200900001 AND ProfTime=8:00:00 AM'
body: <p>I have the following code:</p>
  
  <pre><code>Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)    Handles Button1.Click
  
      Dim cmd As New OleDb.OleDbCommand
      Dim x As New Integer
      Dim profID As New Integer
      Dim date1 As New Date
      date1 = #8:00:00 AM#
      profID = 200900001
      x = 0
      If Not cnn.State = ConnectionState.Open Then
          cnn.Open()
      End If
      cmd.Connection = cnn
      'SerialPort1.Open()
      'SerialPort1.Write("1")
      'Dim readThis As String = SerialPort1.ReadChar()
      'MsgBox(readThis)
      'If readThis = 1 Then
      'End If
      'SerialPort1.Close()
      cmd.CommandText = "UPDATE test " &amp; _
                        "SET ProfLog='" &amp; x &amp; "'" &amp; _
                        "WHERE ProfID=" &amp; profID &amp; "  AND ProfTime=" &amp; date1
      cmd.ExecuteNonQuery()
      MsgBox("DONE!")
  
  End Sub
  </code></pre>
  
  <p>with this code, it says that there is a </p>
  
  <pre><code>Syntax error (missing operator) in query expression 'ProfID=200900001  AND ProfTime=8:00:00 AM'. 
  </code></pre>
  
  <p>What is the missing operator?</p>