Print date entered in Parameter query in the Header of a Report 2

[DataNick]

Hi All!
I've got reports that use Parameter queries as their data source. Is it possible to print in the header of my report, the last date entered as a month/yyyy? I usually use 2 inputs for the date range. So if I enter for example (2/1/04) for the first date, and then (2/28/04) for the second date, is it possible to display that second date entered as February, 2004 in the header of my report?
Thanks for your time,
Nick

 

[gol4]

there are two ways to do this
first since it has parameters I assume you have in the queries criteria [enter_start_date] or something to that effect and the same for end date

in a textbox place ="data between " & [enter_start_date] & " and " & [enter_end_date]

or you can also use dmax()and dmin() functions with the datefield as the field and the reports query as the source

 

[Terpsfan]

The way I would handle this is to use a form interface for the query, perhaps with the calendar control. The user would enter the parameter dates into txtBeginDate and txtEndDate. Then in your report I would create 2 label controls, one for the date range(lblDateRange) and the other for the month(lblMonth).

Private Sub Report_Open(Cancel As Integer)


'Open the report in maximized view
DoCmd.Maximize

'Set the date label to equal the report parameters
Me.Controls("lblDateRange&quot.Caption = "For period between " & Forms("frmCalendarReports&quot("txtBeginDate&quot _
& " and " & Forms("frmCalendarReports&quot("txtEndDate&quot
'Set the month label caption
Me.controls("lblMonth&quot = Format((Forms("frmCalendarReports&quot("txtBeginDate&quot,"mmmm&quot&", "&Year(Forms("frmCalendarReports&quot("txtBeginDate&quot

End Sub

 

[DataNick]

Thanks guys, both of you have given me excellent solutions. I appreciate the community help/spirit, and hope I can be of help to others in the future.
Thanks again,
Nick