DELETE BY DATE

[Tech718]

Hello,
is there a way i can have records automatically removed from a table once a date has passed. I have a table with information and an expiration date for each record. can tables automatically delete the record once the date has arrived/passed?

 

[PHV]

Create a delete query launched by a macro executed with the /x command line option of msaccess.exe in a scheduled job.

DELETE * FROM yourTable
WHERE [expiration date] <= Date()

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886