I have a date field (StartDate). In a query I created a field to extract the year from that field .. vYear: DatePart('yyyy',[StartDate])
This works fine. When I run the query, only the year shows, which is what I want.
What I want to do is have the user enter a year to pull that data. So I placed [Enter Year] in the Criteria.
When I run the query nothing appears.
What am I doing wrong?