Delete all but SQL results

M

Melinda

Hello!
I have a table. I want to delete all but the most recent
record for a given job. I have an SQL statement that does
this. How do I tell VB to delete all of the other records?
Thanks!
Melinda
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete all data after a symbol in a field 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
Can I save a sql statement generated by a search form? 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Improving Macro That Keeps First Letter 0
M.S. Word 365 1
MS Project Center-Autolink column fields 0
Word VBA - Delete text from bulleted paragraphs 1

Top