like clause issue...

[Brad Pears]

I have a report that includes a date value. I would like the user to be able
to enter in a year value only and have the report be based on that year
only.

I figured I could modify the query to include a "like" clause as the
criteria on the date field but I am not having any luck.

What is the syntax of a "like" clause on date fields?

Here's what I tried in the queries "criteria" clause for the date field...

like "#" & [Enter Year] & "#" (did not work)

Thanks,

Brad

 

[Rick B]

Just add a new column to your query to pull the year out of your data...

YearOfRecord: year([somefield])


Then in the criteria put...


[Enter Year]


Rick B