retreving a record that is more than seven years old 1

[JesseNorris]

Hi all

im looking to have a query that will return only the records that are older than 7 years old based on a date_last_closed feild.

any ideas will be a grate help
Regards,
Jesse

 

[JesseNorris]

Its all good guys i think ive worked it out

how odse <(DatePart("yyyy",[nameoffield])-7) sound?

 

[PHV]

And what about this in the criteria cell of date_last_closed ?
<DateAdd('yyyy',-7,Date())

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

 

[JesseNorris]

Thanks PHV

this proves that there is more than one way to fry an egg
Regards,
Jesse