How do you get a date range to display months?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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


Tammy said:
I would like my user to enter the month instead of date numbers. How can
Click to expand...
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.
 
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??
 
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


Tammy said:
I did not think about the year... Bummer.

So if I am going to just use the current year, your formula will work? So
Click to expand...
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
Click to expand...
of date right??
 
Back
Top