Unanswered: Help! Specifying current year in a query criterion?
It's me again!!
Just wondering if there's an expression that can be used as a query criterion to denote the current year, without relying on any other expression like DatePart, etc. For example, you know how =Date() tells you the current date, =Time() tells you the current time, and so forth? I need something similar, except for just the year (in "yyyy") format, so that my query will only return, in the report, a list of menu items added to the menu during the current year. I suppose something as simple as =Year() is too much too hope for - I tried that but Access didn't seem to like it.