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

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

PC Datasheet

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