Year retrieval

[Miskacee]

"I have 5 years of data which has a hiredate". I would only like to retrieve
the current year's data. How do I do this in a query? I tried date(), Now()
but am drawing a blank.

Thank you.

 

[John W. Vinson/MVP]

"I have 5 years of data which has a hiredate". I would only like to retrieve
the current year's data. How do I do this in a query? I tried date(), Now()
but am drawing a blank.

Thank you.

A couple of ways; one that will take advantage of any index on the
hiredate field is to use a query on the table with a criterion of