Including Date Range Parameter in Page Header

  • Thread starter Thread starter Anita Taylor
  • Start date Start date
A

Anita Taylor

I'm working on a report that prompts users to enter a
beginning and ending date range. I'd like to have those
two input parameters appear in the page header for the
report.

I'd like to end up with a report title that says, "Report
of Activity from [BeginningDate] to [EndingDate]"

I've tried a couple of things, but none seem to work. Any
help would be greatly appreciated!
 
I'm working on a report that prompts users to enter a
beginning and ending date range. I'd like to have those
two input parameters appear in the page header for the
report.

I'd like to end up with a report title that says, "Report
of Activity from [BeginningDate] to [EndingDate]"

I've tried a couple of things, but none seem to work. Any
help would be greatly appreciated!
Click to expand...

Add an unbound control to the Report Header.
Set it's control source to:
= "Report of Activity from " & [BeginningDate] & " to " & [EndingDate]

The text within the brackets must be identical to the bracketed text
within the query prompts.
 
Back
Top