title: Error is being thrown in my SQL update statement; Data type mismatch in criteria expression
body: <p>I'm trying to update my table with current records with actual days of the week(Strings), but my code is giving me the error: </p>
  
  <blockquote>
    <p>Data type mismatch in criteria expression</p>
  </blockquote>
  
  <p>I've rigorously checked my SQL statement to ensure that right data types are being used, but I couldn't identify any problems at all.Can someone help me identify where my problem lies and any potential solutions.</p>
  
  <p>The SQL statement is be:</p>
  
  <pre><code>str = "Update [tblAppointments] Set [Day] ='" &amp; day &amp; "' WHERE [TimeID] ='" &amp; redbutton &amp; "'"
  
  redbutton = 18 
  
  day = "wednesday"
  </code></pre>
  
  <p>This is the database I am working with:</p>
  
  <p><a href="https://i.stack.imgur.com/pOZ5x.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pOZ5x.png" alt="database"></a></p>