query search by month

[jaybo]

I'm using a query to look up report criteria by type, response etc using a query to search value in a field ex [Reply]=[Forms]![Form1]![Cmbreply] Or [Forms]![Form1]![Cmbreply] Is Null

I'm trying to work a month look up the problem is the date is set July 25,2005 and my field is searching for the month July not the specific date. I'm stuck on how to look for the month only and ignore the day and year - any ideas

Thank you

 

[Dwight]

Have you tried using the Month function? If you put Month(yourdate) it will return the month number.

See if that helps.