delete query

[tom]

How do I write a query that will delete all rows in a
table where the date column is greater than 30 days old?

Thanks in advance!

Tom

 

[martin]

DELETE [invoice date]+30 AS idate, [a/r open].*
FROM [a/r open]
WHERE ((([invoice date]+30)<Date$()));

Not sure if it is a plus or minus 30 please double check!

Hope this helps

Martin

 

[John Spencer (MVP)]

DELETE * FROM YourTable
WHERE TheDateField < Date()-30

Or

DELETE ...
WHERE TheDateField < DateAdd("d",-30,Date())

TEST on a copy of your data to see if it works.