<div>
<div class="content wysiwyg-content">
I have a SQL query that queries and Access 2000 database for the records between a particular period &nbsp;The declarations are as follows<br />
<br />
txtdate1 as textbox<br />
txtdate2 as text box<br />
<br />
ADODC.recordsource = &quot;&nbsp;Select * from Sale where Hdate between &quot;&nbsp;&amp; txtdate1.text &nbsp;&amp; &quot;&nbsp;AND &quot;&nbsp;&amp; txtdate2.text<br />
<br />
ADODC.refresh<br />
<br />
The result of the query does not alter the recordsource. &nbsp;I think there is something wrong with query<br />
<br />
Tks in advance<br />
<br />
Ivanc
</div>
</div>


I have a SQL query that queries and Access 2000 database for the records between a particular period  The declarations are as follows

txtdate1 as textbox
txtdate2 as text box

ADODC.recordsource = " Select * from Sale where Hdate between " & txtdate1.text  & " AND " & txtdate2.text

ADODC.refresh

The result of the query does not alter the recordsource.  I think there is something wrong with query

Tks in advance

Ivanc

SQL - Between ... AND

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.