<div>
Chances are that your [SentDate] field includes a time component. &nbsp;I generally use:<br />
<br />
WHERE DateValue(tblClaims.Invoic<wbr />eSentDate)<wbr /> &gt;= DateValue([Forms]![form1]!<wbr />[text63])<br />
AND DateValue(tblClaims.Invoic<wbr />eSentDate)<wbr /> &lt;= DateValue([Forms]![form1]!<wbr />[text65])
</div>


<div>
but you probably don't need the DateValue referring to your form controls.<br />

<pre><code class="code-1 nolinks" id="code-20-42352735-1"><span>WHERE DateValue(tblClaims.InvoiceSentDate) &gt;= cdate([Forms]![form1]![text63])</span>
<span>AND DateValue(tblClaims.InvoiceSentDate) &lt;= cdate([Forms]![form1]![text65]) </span>
</code></pre>
This assumes you have other code that would require that text63 and text65 contain values. &nbsp;Otherwise, you might want to use the NZ() function to force dates into those criteria.<br />
<br />
BTW. &nbsp;I strongly recommend a control naming convention txt_FromDate, txt_ThruDate instead of accepting the default control names that Access assigns to controls on your form. &nbsp;It is much easier to write code and debug it when the control names have meaning.
</div>


<div>
Updated. Please try . No need to put DATEVALUE around texts are they are dates only.<br />
<br />
WHERE ((DATEVALUE(tblClaims.Invo<wbr />iceSentDat<wbr />e) Between [Forms]![form1]![text63] And [Forms]![form1]![text65]) AND ((Customers.Company)='USAA<wbr /> INSURANCE COMPANY')) OR (((Customers.Company)=&quot;Sch<wbr />wartz Law Firm, PC&quot;)) OR (((Customers.Company)=&quot;Gar<wbr />an, Lucow, Miller, PC&quot;));<br />
<br />
OR <br />
<br />
WHERE ((DATEVALUE(tblClaims.Invo<wbr />iceSentDat<wbr />e) &gt;= [Forms]![form1]![text63] And <br />
DATEVALUE(tblClaims.Invoic<wbr />eSentDate)<wbr /> &lt;= [Forms]![form1]![text65]) AND ((Customers.Company)='USAA<wbr /> INSURANCE COMPANY')) OR (((Customers.Company)=&quot;Sch<wbr />wartz Law Firm, PC&quot;)) OR (((Customers.Company)=&quot;Gar<wbr />an, Lucow, Miller, PC&quot;));
</div>


<div>
Another solution, which avoids the use of VBA functions in the &nbsp;WHERE clause which can adversely affect performance:<br />
<br />
WHERE tblClaims.InvoiceSentDate &gt;= [Forms]![form1]![text63]<br />
AND tblClaims.InvoiceSentDate &lt;&nbsp;[Forms]![form1]![text65] +1<br />
<br />
PS - best practice is to actually name controls and forms with meaningful names. &nbsp;You aren't going to know next week what text65 is let alone next year.
</div>


<div>
<div class="content wysiwyg-content">
I have a query below, when the user enters on form1<br />
<br />
10/1/2017 &nbsp; &nbsp; &nbsp; [text63] which is the earliest date<br />
10/31/2017 &nbsp; &nbsp; [text65] which is the latest date<br />
<br />
The results do not include 10/31 they only show up to 10/30.<br />
<br />
What is the syntax to be used to include all rows that are from one to to and including another date?<br />
<br />
<br />
<br />
<br />
WHERE (((tblClaims.InvoiceSentDa<wbr />te) Between [Forms]![form1]![text63] And [Forms]![form1]![text65]) AND ((Customers.Company)='USAA<wbr /> INSURANCE COMPANY')) OR (((Customers.Company)=&quot;Sch<wbr />wartz Law Firm, PC&quot;)) OR (((Customers.Company)=&quot;Gar<wbr />an, Lucow, Miller, PC&quot;));
</div>
</div>


I have a query below, when the user enters on form1

10/1/2017       [text63] which is the earliest date
10/31/2017     [text65] which is the latest date

The results do not include 10/31 they only show up to 10/30.

What is the syntax to be used to include all rows that are from one to to and including another date?




WHERE (((tblClaims.InvoiceSentDate) Between [Forms]![form1]![text63] And [Forms]![form1]![text65]) AND ((Customers.Company)='USAA INSURANCE COMPANY')) OR (((Customers.Company)="Schwartz Law Firm, PC")) OR (((Customers.Company)="Garan, Lucow, Miller, PC"));

How to retrieve date between two dates.

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.