Automatically Delete Records from a Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello-
I would like to automatically delete all of the records in a table that meet
a certain criteria in a specific field of a specific column. Example, delete
all records that have 2008 in the fields of the Year Column.
Thank you for any info that would point me in the right direction.
Filo
 
Create a Delete query and place the required parameter in the criteria field.
Does that explain enough or am I think the simple way?
 

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

Record insert/delete anomaly 0
Access Automatically Send a notification email once a record is added 0
Access Dcount (multiple criteria) 3
Adding records in DETAIL table automatically from master 3
DELETE FROM a table WHERE... 1
Deleting records 2
Update certain record fields in one table if data exists in anothe 1
Delete records in other tables when one selection is chosen? 8

Back
Top