I have a query set up that it gets its input for criteria from a form. one of the criteria is a year, the problem im having is that it is a date field in the table, but all I want to filter is the year.
example of what I need:
input on form - 2008
date field on query - 5/15/2008
6/4/2008
6/23/2008 ...etc.
I'm sure its an easy fix but I'm new at this stuff and am looking for all the help I can get.