Filtering Date by Year

  • Thread starter Thread starter Chip
  • Start date Start date
C

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!!!!
 
Add a calculated field to your query:
YearFind: Year([DateFieldName])

Set its criterion expression to this:
[Enter the year:]
 
Try this as the criteria for the date field:

Like "*/*/2003"

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