How do you get a date range to display months?

[Tammy]

I would like my user to enter the month instead of date numbers. How can I use a form to create the range for the query? I want the title to display the month, but the query to use the date range

Thank you

 

[Duane Hookom]

What would you do about the day of the month and year? You could set the
criteria to:
Between DateValue(Year(Date()), Forms!frmA!cboStartMth, 1) and
DateValue(Year(Date()), Forms!frmA!cboEndMth +1,0)

--
Duane Hookom
MS Access MVP

I would like my user to enter the month instead of date numbers. How can

I use a form to create the range for the query? I want the title to display
the month, but the query to use the date range.

 

[Tammy]

I did not think about the year... Bummer.

So if I am going to just use the current year, your formula will work? So I do not have to put a start and end date, and just ask the user for the month

Then I just put the value in the title and it will put the month instead of date right??

 

[Duane Hookom]

I would use combo boxes on the form to drop down a list of month numbers and
names. You can reference the combo boxes in a report just like you would in
a query.

--
Duane Hookom
MS Access MVP

I did not think about the year... Bummer.

So if I am going to just use the current year, your formula will work? So

I do not have to put a start and end date, and just ask the user for the
month?

Then I just put the value in the title and it will put the month instead

of date right??