date control functions

[CallGlen]

I want to use a delete query to automatically delete information 4 years old.
Is there something I can type into the "<now()" criteria to specify four
years?
Glen Longstreet

 

[Duane Hookom]

You can use the DateAdd() function:
<DateAdd("yyyy",-4,now())