delete query (delete months that are >=25 months old)

[mwheads]

Hi All

What criteria do I use in a delete query if I want to keep a stock of 2 years and delete anything that is 25 Months+.
Field name is Month

I can get it right in days but not in months.

Thanks

 

[PHV]

I can get it right in days but not in months
So, 2 years should be 730.5 days.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244