Purge Records

  • Thread starter Thread starter Kimber
  • Start date Start date
K

Kimber

I'm working on a database for Realtors. It's for contract
deadlines. I need help with a statement that will clear
all the old records out say 30 day old from their closing
date. Can anyone help with the statement that will do
that.
 
DELETE FROM MyTable WHERE ClosingDate < DateAdd("d", -30, Date())

(Replace MyTable and ClosingDate with the appropriate names)
 
Back
Top