Filtering Date by Year

[Chip]

I have a simple query that has a date with the format of 'dd-mmm-yyyy' but i
want the person to put in a year like '2003' when the query is ran so it
only shows the dates in 2003. How can i do that with an ACCESS Query?

Once again, Thanks in advance!!!!

 

[Ken Snell]

Add a calculated field to your query:
YearFind: Year([DateFieldName])

Set its criterion expression to this:
[Enter the year:]

 

[Ashby]

Try this as the criteria for the date field:

Like "*/*/2003"

If it is a paramenter query then:
Like "*/*/" & [Enter Year]