Purge Records

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

 

[Douglas J. Steele]

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

(Replace MyTable and ClosingDate with the appropriate names)