I'm working on a database to track camp registration and I want to restrict some reports to the current year. I am trying to filter records in a query by using the start date for the camp [BegDate], extracting the year and comparing it to the current year using Year(Now()). The problem is that Year (Now()) is returning 1905 instead of 2006.
I know there's some feature in Access that determines how dates will be read but I can't remember what or where. Is there something I need to change in my settings or is there another way to do what I'm trying to do?