<div>
or use<br />
<br />
DateValue([DateField]) Between Forms!frmMainMenu!txtStart<wbr /> and Forms!frmMainMenu!txtEnd<br />

</div>


or use

DateValue([DateField]) Between Forms!frmMainMenu!txtStart and Forms!frmMainMenu!txtEnd


<div>
<div class="content wysiwyg-content">
I have a form with two fields... txtStart and txtEnd. &nbsp;Then in my query syntax I have...<br />
Between Forms!frmMainMenu!txtStart<wbr /> and Forms!frmMainMenu!txtEnd<br />
<br />
If I enter today's date in both fields I get 10 returns returned with today's date. &nbsp;But if I enter today's date as the start date and tomorrow's date as the end date I get more records that contain today's date and some with tomorrow's date. &nbsp;Why am I not seeing all of today's records when I enter today's date in both fields?<br />
<br />
--Steve
</div>
</div>


I have a form with two fields... txtStart and txtEnd.  Then in my query syntax I have...
Between Forms!frmMainMenu!txtStart and Forms!frmMainMenu!txtEnd

If I enter today's date in both fields I get 10 returns returned with today's date.  But if I enter today's date as the start date and tomorrow's date as the end date I get more records that contain today's date and some with tomorrow's date.  Why am I not seeing all of today's records when I enter today's date in both fields?

--Steve

Problem with date range in a query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.