is there a function to grap the current year

[LoryW]

I have a field in access that only have a year. The field consist of
different years. I only want to use the data for the current year. I do not
want to hard code the year in. So is there a year statement or function I
can use.

 

[fredg]

I have a field in access that only have a year. The field consist of
different years. I only want to use the data for the current year. I do not
want to hard code the year in. So is there a year statement or function I
can use.

As criteria on your query, you can use:
Where TableName.YearField = Year(Date())

Change TableName and YearField to whatever the actual names are.