is there a function to grap the current year

L

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

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

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

Change TableName and YearField to whatever the actual names are.
 
Top