Query to delete records that are before 90 days from today

[bball]

How do I in Access create a query to delete all the records that are in an
sql databasde before 90 days from todays' date?
Thanks.
I need to delete all records before Today minus 90, in other words we want
to keep the last 90 days worth.

 

[Alex Dybenko]

something like this:

Delete * from MyTable Where (Date()-MyTable.MyDateField) > 90

 

[Douglas J. Steele]

It might be marginally faster to use

Delete * from MyTable Where MyTable.MyDateField < Date() - 90

I think Jet is smart enough to know that it only has to figure out Date()-90
once, rather than doing the arithmetic for each row.