I have a form that has four combo boxes
FromMonth, FromYear, ToMonth, ToYear
I have a dropdown list for each of them. I am doing it this way, because the data comes in once every month. So only month and year are relevant.
I use the following code to convert them to date format:
fromdate = DateValue(Me.Frommonth & "/" & "01/" & Me.Fromyear)
todate = DateValue(Me.Tomonth & "/" & "01/" & Me.Toyear)
My table has a date field. I would like to run a query from the above form for all dates between fromdate and todate.
How do I do this?
FromMonth, FromYear, ToMonth, ToYear
I have a dropdown list for each of them. I am doing it this way, because the data comes in once every month. So only month and year are relevant.
I use the following code to convert them to date format:
fromdate = DateValue(Me.Frommonth & "/" & "01/" & Me.Fromyear)
todate = DateValue(Me.Tomonth & "/" & "01/" & Me.Toyear)
My table has a date field. I would like to run a query from the above form for all dates between fromdate and todate.
How do I do this?