Right off the top, I'd like to mention that I am trying to build this query in Query Design and not VBA, so that it can be used in a report chart.
I have a field with the date stored as yyyy-mm (2020-05). I'm trying to build a SELECT query that will pull data where the field has the current year. What I currently have is:
I don't get any errors with this, but the search pulls up empty. Can someone please assist?
I have a field with the date stored as yyyy-mm (2020-05). I'm trying to build a SELECT query that will pull data where the field has the current year. What I currently have is:
Code:
SELECT Field1
FROM Table1
WHERE Field1 Like "*(Year(Now()))*";