Run Query from date to date, Print the from date to date in the header of the report?

  • Thread starter Thread starter Dustin Swartz
  • Start date Start date
D

Dustin Swartz

My Query prompts me for a "from date" and a "to date"

Now how can I get that Date span to print on my report header?
 
The parameters are treated as just another field in the returned recordset,
so use
something like this in the Open event of the report:

Me.Caption = "THIS REPORT BEGINS ON "& [Enter Start Date] _
& " AND ENDS ON " & [Enter Ending Date]
 
Back
Top