Is it possible to have query criteria auto-update?

ml8889

Registered User.
Local time
Today, 18:43
Joined
Oct 12, 2012
Messages
19
I have a query that has a Year field. I want the report and form that I generate from this query to only show current year results. I already put 2012 in the criteria area of the field for now. Is it possible for me to write an expression (or other) that will update to 2013 when the new year rolls around? And then 2014, etc. etc.? Or do I have to manually do this at the turn of each year? Please advise. Thanks!
 

Users who are viewing this thread

Back
Top Bottom