title: SQl queries searching by date range
body: <p>I have a table in an Access 2007 database. All fields are of type text. Can the following be done using the where clause? If so how?</p>
  
  <ul>
  <li>SELECT * from Table1 WHERE (ColumnDate is between 26th and 19th of march 2010)</li>
  <li>SELECT * from Table1 WHERE (ColumnAge is between 25 and 40)</li>
  </ul>
  
  <p>The usual &lt; &lt;= operators don't seem to work.</p>
  
  <p>Thanks,</p>