Report Header Lookup Question

  • Thread starter Thread starter Adam
  • Start date Start date
A

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.
 
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.
Click to expand...

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.
 
That worked perfectly. Thank you very much!


fredg said:
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.
Click to expand...

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.
Click to expand...
 
Back
Top