Query designer criteria using month number
Posted on 2015-01-27
I have a query that has a field named "DueDate". In this date field is for example 01/15/2015 or 03/25/2016 or 10/23/2017.
I also have a form where the user selects a month from a combobox. So January is 1, February is 2, etc.
If the user selects, for example, March, then I want the query to return all records that have a DueDate of March (any day in March) OR BEFORE.
What would the query criteria be for the DueDate field? The form they use to select the month is frmSelectMonth and the combobox is named cboSelectMonth. Also when they select the month name from the combobox a text field named txtMonthN fills in with the month number if that is needed for this.
I hope I haven't confused everyone.