Auto-Delete Table

[benperrydog]

Hi y'all,

Sorry, this is a newbie question: I have a table of undeliverable email addresses and I need these to be deleted from a larger table through some sort of recordset.delete routine. Any takers?

 

[Terpsfan]

You could run a Delete query daily or for whatever period you specify. The query criteria would simply be those emails that are undeliverable. It will only delete those records and leave the rest intact.

DELETE *
FROM tablename
WHERE (((emailaddressfield)="markedundeliverable&quot);