Select a date range from a calendar control to generate a report

[Tarena]

I have a report that is generated by a query. I have a form with a calendar control. I would like to use the form to force my date range to generate my report. Any suggestions? Do I need to give some more information???

Basically, I would like to set my date range for my report by using a calendar to select the beginning and ending dates.

[FishVal]

I have a report that is generated by a query. I have a form with a calendar control. I would like to use the form to force my date range to generate my report. Any suggestions? Do I need to give some more information???

Basically, I would like to set my date range for my report by using a calendar to select the beginning and ending dates.

Hi!

You should first decide how do you want to select two dates. Possible ways are:

• to use two calendar controls for beginning date and ending date
• to use two additional buttons to retrieve beginning date and ending date respectively from calendar control
• to use two datepicker controls
• something else you like

[Tarena]

Hi!

You should first decide how do you want to select two dates. Possible ways are:

• to use two calendar controls for beginning date and ending date
• to use two additional buttons to retrieve beginning date and ending date respectively from calendar control
• to use two datepicker controls
• something else you like

I have a form now that you click on a date and then input the number of days you want in the range and it gives you the start date (the date you clicked on) and the end date (the last date in the range). I really don't care, which ever would be the easiest for any user to use. But I do need to be able to see the calendar and click on the days to select them and have it generate the report using the selected dates.

[FishVal]

I have a form now that you click on a date and then input the number of days you want in the range and it gives you the start date (the date you clicked on) and the end date (the last date in the range). I really don't care, which ever would be the easiest for any user to use. But I do need to be able to see the calendar and click on the days to select them and have it generate the report using the selected dates.

Something like this
axcCalendar - Calendar control name
txtDays - textbox with number of days

Private Sub btnOpenReport_Click()
 
    Dim strDocName As String, strCriteria As String
 
    strDocName = "rptReport"
    With Me
        strCriteria = "dteDate >= #" & .axcCalendar & _
            "# AND dteDate < #" & DateAdd("d", Nz(.txtDays), .axcCalendar) & "#"
    End With
 
    Debug.Print strCriteria
    DoCmd.OpenReport strDocName, acPreview, , strCriteria
 
End Sub