is there a function to grap the current year

  • Thread starter Thread starter LoryW
  • Start date Start date
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.
 
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.
 
Back
Top