Year Question

[LMRollins]

I want to be able to show only the last 2 years of info in my database. I know I can go into the query and tell it to show only >=2003 but I need to make it automated so that I don't have to change it every year. Does anyone of a formula that I can use that will do this?

Lori

 

[dhookom]

>=Year(Date())-1

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[THWatson]

Lori
In your query, create a new column with the expression
Year([YourDateField])

Then put in criteria in the same column
>=Year(Date())-2

Tom

 

[THWatson]

Lori
Sorry. My criteria should have been
>=Year(Date())-1

Tom