<div>
I will leave it for others who get in the same fix
</div>


I will leave it for others who get in the same fix

<div>
<div class="content wysiwyg-content">
Using MS Access 2007 I have the following delete SQL:<br />
<br />

<pre><code id="code-10-28534584-1">strDelete = &quot;DELETE * FROM tblContractorSummary WHERE cn_hauldate &lt; #&quot; &amp; Me!txtStart &amp; &quot;# AND cn_hauldate &gt; #&quot; &amp; Me!txtEnd &amp; &quot;#;&quot;
db.Execute (strDelete)</code></pre>
<br />
No error is thrown but no records get deleted either. <br />
<br />
Where did I go wrong?<br />
<br />
Thanks<br />
<br />
PBLack
</div>
</div>


Using MS Access 2007 I have the following delete SQL:

(CODE)

No error is thrown but no records get deleted either. 

Where did I go wrong?

Thanks

PBLack

Problem with delete SQL based on medium date type.

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.