D Dustin Swartz Jan 25, 2005 #1 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?
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 Jan 25, 2005 #2 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]
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]