jack3_99

<div>
Basically the sub query idea ...
</div>


<div>
It works great. &nbsp;Thank you for your help. &nbsp;I appreciate it very much.
</div>


It works great.  Thank you for your help.  I appreciate it very much.

<div>
<div class="content wysiwyg-content">
I have set up a Delete query in Access. &nbsp;I am trying to delete records from the tblGLDetails table. &nbsp;The criteria is based on a date stored in the DateCreated field in the tblExtractDate table. &nbsp;There is only one date saved in the tblExtractDate table.<br />
<br />
The records are displayed when I select View; however, I receive the error “Could not delete from specified tables” when I run the query.<br />
<br />
Thank you in advance for your help.<br />
<br />
The following is the SQL code for the query:<br />

<div class="indent">
DELETE tblGLDetails.*, tblGLDetails.DateCreated, tblGLDetails.Senario<br />
FROM tblGLDetails, tblExtractDate<br />
WHERE (((tblGLDetails.DateCreate<wbr />d)&gt;=[tblEx<wbr />tractDate]<wbr />![DateCrea<wbr />ted]) AND ((tblGLDetails.Senario)=&quot;A<wbr />ctual&quot;));
</div>
[/indent]<br />
<br />
The following is the Design view of the Access Delete query:<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/01_w04/1410153/Screenshot.PNG" target="_blank" title="Screenshot of the Access Design View of the Delete query (15 KB)"><img alt="Screenshot of the Access Design View of the Delete query" class="file-block lazyload" style="max-width: 467px;" data-src="https://filedb.experts-exchange.com/incoming/2019/01_w04/1410153/Screenshot.PNG" /></a>
</div>
</div>


Screenshot of the Access Design View of the Delete query

Screenshot.PNG

I have set up a Delete query in Access.  I am trying to delete records from the tblGLDetails table.  The criteria is based on a date stored in the DateCreated field in the tblExtractDate table.  There is only one date saved in the tblExtractDate table.

The records are displayed when I select View; however, I receive the error “Could not delete from specified tables” when I run the query.

Thank you in advance for your help.

The following is the SQL code for the query:
DELETE tblGLDetails.*, tblGLDetails.DateCreated, tblGLDetails.Senario
FROM tblGLDetails, tblExtractDate
WHERE (((tblGLDetails.DateCreated)>=[tblExtractDate]![DateCreated]) AND ((tblGLDetails.Senario)="Actual"));[/indent]

The following is the Design view of the Access Delete query:


Could not delete from specified tables

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.