Filtering Form by Year

I have a holiday form which gives yearly Holiday allowance, Days carried over, etc for each of 30 employees. I have a separate record for each employee for each year. I have a subform  with the days taken for each year.

I want to "simply" filter records so that on the current year is shown. Currently I have the year field as a text field.
Who is Participating?
mbizupConnect With a Mentor Commented:
Try this in your query...

WHERE YourYearField = Year(Date())

Or in VBA

Me.Filter = "YourYearField = Year(Date())"
SparkyPAuthor Commented:
Once again, What can I say?

Many Thanks
Glad to help :)
SparkyPAuthor Commented:
Sorry for the delay
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.