Query criteria from form (just the year)

[user622]

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.

[rpeare]

create a field in your query:

SearchYear: datepart("yyyy", <datefieldname>)

Then use the criteria you're entering from your form

forms!<formname>!<fieldnameonform>

[user622]

Thanks! worked like a charm.