 <p>Don't use string comparisons for date/times.</p> <pre><code>SELECT event_cust.* FROM event_cust WHERE TimeValue([start_time]) &gt;= CDate([Forms]![CustEventRptForm]![FromHour]) AND TimeValue([start_time]) &lt;= CDate([Forms]![CustEventRptForm]![ToHour]) </code></pre>