Auto calc of Year for Query

[pat_nospam]

I need to autocalculate the year for a query, so I don't have to update it on an annual basis. I can autoinput the date, but don't know how to just get the Year. Will Year() do the trick, and if so, what variables indicate how to go back 2 years (Year(),-2)?

Thanks in advance

 

[dcx693]

Year(Date) will get you the current year. Year(Date)-2 will get you two years ago.

 

[pat_nospam]

You rock Thanks