 <pre><code>SELECT * from Table1 WHERE (CDATE(ColumnDate) BETWEEN #03/26/2010# AND #03/19/2010#) SELECT * from Table1 WHERE (CINT(ColumnAge) between 25 and 40) </code></pre> <p>Dates are represented in Access between <code>#</code> symbols in <strong><code>#MM/DD/YYYY#</code></strong>. You should really be storing the date as a date field :)</p>