Year retrieval

M

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.
 
J

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.
Click to expand...

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
 
Top