Purge Records

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.
 
D

Douglas J. Steele

DELETE FROM MyTable WHERE ClosingDate < DateAdd("d", -30, Date())

(Replace MyTable and ClosingDate with the appropriate names)
 
Top