title: Data Type Mismatched Query
body: <p>i'm using VB and Access, tried to use Select Statement filtering WHERE EmployeeID equals to userInput which is an int value, but giving me an error Data type Mismatched</p>
  
  <pre><code>Set MyRec = MyDB.OpenRecordset("SELECT * From EmployeeTable WHERE EmployeeID ='" &amp; userInput &amp; "' ")
  </code></pre>
  
  <p>I'm guessing it has something to do with how you construct the query when it comes to WHERE INT VALUES statement. Please help Thanks Guys.</p>