checking if current year

[snoopy]

Hi community,

I am searching for a simple criteria in a query. I've just want to check if the selected year is the current one.

In specific row there just types of year.

Eg.
2012
2013
2012
2012
2014

At the end it just have to show only 2012, cause current year. Hopefully someone understands and could help me out with

[Kirsti]

Hi there,

In the field row of your query: Year([YourField])

and in the Criteria row of the same field: Year(Now())

This will only return those values where the year is 2012. Is that what you need?

[snoopy]

He,

that is exactly what I am searched for