Report Header Lookup Question

[Adam]

I have a report running from a parameter query where a start and end date are
entered and then the report opens within those dates. I want the report name
to look something like this...

Jobs Worked from ________ to _________.

How would I make the dates entered in the parameter boxes populate to the
header title?

Any help is much appreciated.

 

[fredg]

I have a report running from a parameter query where a start and end date are
entered and then the report opens within those dates. I want the report name
to look something like this...

Jobs Worked from ________ to _________.

How would I make the dates entered in the parameter boxes populate to the
header title?

Any help is much appreciated.

Add an unbound control to the report header.
Set it's control source to:
="Jobs Worked from " & [Enter Start Date] & " to " & [Enter End Date]

The bracketed text above must be identical to the bracketed text in
the query parameter.

 

[Adam]

That worked perfectly. Thank you very much!

I have a report running from a parameter query where a start and end date are
entered and then the report opens within those dates. I want the report name
to look something like this...

Jobs Worked from ________ to _________.

How would I make the dates entered in the parameter boxes populate to the
header title?

Any help is much appreciated.

Add an unbound control to the report header.
Set it's control source to:
="Jobs Worked from " & [Enter Start Date] & " to " & [Enter End Date]

The bracketed text above must be identical to the bracketed text in
the query parameter.