Coordinator

ssblue

<div>
<pre><code id="code-20-42812424-1">Delete * FROM YourTable WHERE [New_Interval]   &lt;  1001</code></pre>
But it would better to give us a better info about your table design along with some sample data
</div>


Delete * FROM YourTable WHERE [New_Interval]   <  1001

But it would better to give us a better info about your table design along with some sample data

<div>
Thanks again for the information. You are correct in that I needed to delete all tagnumbers which had a new_interval &lt;1001 associated with it.
</div>


Thanks again for the information. You are correct in that I needed to delete all tagnumbers which had a new_interval <1001 associated with it.

<div>
<div class="content wysiwyg-content">
Access: &nbsp;I have a table with 1.7 million records of tasking and each line of tasingk has a New_Interval (number) and a Tag_Number associated with it. &nbsp;I need to delete some records.<br />
I need identify the records to delete by using the Tag_Numbers that have a New_Interval &nbsp; &lt;&nbsp; 1001<br />
Then I need to also delete all records associated with those same Tag_Numbers.<br />
<br />
Some Tag_Numbers have tasking with a New_Interval &lt;1001 and tasking with a &nbsp;New_Interval &gt;1001
</div>
</div>


Access:  I have a table with 1.7 million records of tasking and each line of tasingk has a New_Interval (number) and a Tag_Number associated with it.  I need to delete some records.
I need identify the records to delete by using the Tag_Numbers that have a New_Interval   <  1001
Then I need to also delete all records associated with those same Tag_Numbers.

Some Tag_Numbers have tasking with a New_Interval <1001 and tasking with a  New_Interval >1001

Access need to delete records

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.