Filter by Month

[chrisms]

I have a table where records are entered and one of the fields contains a date/time in the form 27/04/2004 13:51:00.

I need to create a query where the results are filtered by month, the month having been chosen by the user from a form in the step before. How do I get the filter to connect the text of a month from the form to the /04/ part of the date field, and then apply the filter.

Thanks for any help

Chrisms

 

[IgorB]

"Select YourFieldDate
where Month(YourFieldDate)=Month(Forms!YourFormName.txtInputDate)"

Something like this.