<div>
sqlString = &quot;SELECT * FROM yourtable WHERE datefield = '&quot; &amp;&nbsp;Date + 2 &amp;&nbsp;&quot;';&quot;<br />
<br />
S<br />

</div>


sqlString = "SELECT * FROM yourtable WHERE datefield = '" & Date + 2 & "';"

S


<div>
Sorry, access, not sql srever:<br />
<br />
sqlString = &quot;SELECT * FROM yourtable WHERE datefield = #&quot; &amp;&nbsp;Date + 2 &amp;&nbsp;&quot;#;&quot;<br />
<br />
S<br />

</div>


Sorry, access, not sql srever:

sqlString = "SELECT * FROM yourtable WHERE datefield = #" & Date + 2 & "#;"

S


<div>
Shuali, I got an error saying characters at end of sql statement. TitoBobs worked fine. <br />
I now have another question but will post separately for more points.<br />
<br />
Thanks<br />
tmurray22
</div>


Shuali, I got an error saying characters at end of sql statement. TitoBobs worked fine.
I now have another question but will post separately for more points.

Thanks
tmurray22

<div>
<div class="content wysiwyg-content">
I would like to setup a query for my access database that will return all records<br />
that have an EndDate 2 days from the current date.<br />
<br />
<br />
Thanks<br />
tmurray22
</div>
</div>


I would like to setup a query for my access database that will return all records
that have an EndDate 2 days from the current date.


Thanks
tmurray22

Query all End-Dates 2 days from now

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.