<div>
Once again, What can I say?<br />
<br />
Many Thanks
</div>


<div>
<div class="content wysiwyg-content">
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 &nbsp;with the days taken for each year.<br />
<br />
I want to &quot;simply&quot; filter records so that on the current year is shown. Currently I have the year field as a text field.
</div>
</div>


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.

Filtering Form by Year

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.