Getting month from date to use it as a criteria

[Alfred]

Hi. So I'd like to use month as a criteria in a select query. Or to be
exact; I have a combobox witch has list of months, and after the user has
selected some month I'd like use the month number as a criteria to get
specific records...

Best Regards, Alfred

 

[Allen Browne]

Your combo box needs 2 columns: one containing the number 1 to 12, and the
other with the month names.

You can then refer to the combo in the query. Enter a calculated field like
this:
WotMonth: Month([YourDateField])
and in the Criteria row under this:
[Forms]![MyForm]![MyTextBox]