simple code required

[superhorse]

Just a quick one to ask is there some simple code for the following problem.

In a query I want the criteria for a date field to display all the dates when the month in a text box on a form matches the month for the field the criteria is being entered into. All dates are in the format dd/mm/yyyy and I'm not sure how to search just the month.

Any help would be appreciated, cheers.

 

[georgedwilkinson]

Look up DatePart() in Access help. You can isolate the month by using the option "m". But be certain that your regional settings are right, first.

 

[pbaldy]

In SQL view, try

WHERE Month(DateField) = Month(Forms!FormName.TextBoxName)

or just the form reference if all that's in the textbox is a number 1-12.

 

[superhorse]

Cheers guys, problem solved!