title: Cast string data type to Int in SQL QUery for MS Access
body: <p>I am trying to write a query in access that will pull results that are
  in the database in a text
  Acually,I have RECEIPTNO Column whose datatype is TEXT in Table Membership, &amp; I want to pull all the results from RECEIPTNO column where RECEIPTNO is BETWEEN 1 AND 10</p>
  
  <p>And I tried Below Code.</p>
  
  <pre><code>SELECT Cint(RECEIPTNO) FROM MEMBERSHIP where Cint(RECEIPTNO) BETWEEN 1 AND 10
  </code></pre>
  
  <p><strong>Result is: Overflow ,</strong>
  Any Idea?</p>