Printing Date Range

[jake7363]

Hi,
I am designing a report based on a query using BETWEEN in reference to dates.
The question is, how do i get the date range to be printed on the report?

Thanks in advance,
Jake

 

[rjoubert]

If you are using DoCmd.OpenReport to open the report, you can pass the date range as a string in the OpenArgs parameter (of DoCmd.OpenReport)...

DoCmd.OpenReport "Report1", acViewPreview, , , , "Date Range: " & dtmFromDate & " TO " & dtmEndDate

 

[rjoubert]

Then, in the Open event of your report, you can set an unbound field in your report header to the value of OpenArgs...

Me.txtDateRange.Value = OpenArgs

 

[jake7363]

Thanks much!!!