title: Why do I get "data type mismatch in criteria expression?"
body: <p>I am very new to access ( I usually use MySQLi with Navicat) and I need to convert 10 digit isbn numbers to 13 digit.  I have the following query that calls a function to do just this ( I did not create the function, but it works and I use it when performing other queries):</p>
  
  <pre><code>    SELECT ISBN1013([ISBN]) AS ISBN13, LastSoldDate AS LastSold, Id AS Sku, OnHand AS Quantity, Store 
  FROM [Store Inventory]
  WHERE (((ISBN1013([ISBN])) Like "##########?"));
  </code></pre>
  
  <p>When I attempt to run it, everything looks fine at first, then I get an error message that states:  Data Type Mismatch in Criteria Expression.  I have tried to look this up on Google and here, but I am not finding anything that explains this error.
  Can anyone help me out?</p>
  
  <p>EDIT: Here a samples of how the information starts and how it should end up looking.</p>
  
  <pre><code> 0448431351 -&gt; should end up as 9780448431352
   0736425543 -&gt; should be 9780736425544
  </code></pre>