Filtered query question

[Guest]

I am building a query to filter records by date. what I need is to have the
query only present the records that are older then 3 years from today. So
basically, if the year is 2007 I would like to see all the records from 2004
back.

 

[Allen Browne]

Try this in the Criteria row under your date field:

<= DateAdd("yyyy", -3, Date())

 

[Guest]

wow, that works great. thank you.

Try this in the Criteria row under your date field:

<= DateAdd("yyyy", -3, Date())