Including Date Range Parameter in Page Header

[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!

 

[fredg]

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!

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.

 

[Anita Taylor]

Thank you VERY much! This worked like a charm!