Getting month from date to use it as a criteria

  • Thread starter Thread starter Alfred
  • Start date Start date
A

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
 
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]
 
Back
Top