title: "Data type mismatch in criteria expression" error in Access SQL query from C#
body: <p>I am getting below Error, When I put Multiple Conditions with WHERE Clause.
  Error:- Data type mismatch in criteria expression.</p>
  
  <p>My Query:-</p>
  
  <pre><code>this.query = "UPDATE [Attendance] SET [TimeOut]='" + DateTime.Now.ToShortTimeString() + "' WHERE [Emp_Id]='" + txtEmpId.Text + "'and[Date]='" + this.Date + "'";
  </code></pre>