Deleting 5 year old records!

[atiq]

i know this must be a piece of cake but i'm new to Access!

Anyway, am using a delete query and want an expression that i can use in the criteria to allow me to detect (and delete) records that are 5 years old. i used Date() - 1825 but was wondering if there was any other way or function that would allow me to acheive this. any help regarding this would be appreciate! hope someone can help.

 

[rainman89]

Sure how about
if DateAdd("y",5,[yourdatefield])<date() Then
Delete

 

[EdFred]

Sometimes I just do it manually. Make a simple query for that table with the date <= now()-1825 and then click the upper left corner, and hit the delete button. Voila! Don't even bother saving the query.

 

[atiq]

Thanks mate!

Sure how about
if DateAdd("y",5,[yourdatefield])<date() Then
Delete

Thanks for that rainman89! really do appreciate this.

 

[rainman89]

Not a problem! glad to help