Report Header Lookup Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 18 Mar 2008 23:29 GMT

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.

Reply to this Message

fredg - 18 Mar 2008 23:40 GMT

> 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
[quoted text clipped - 6 lines]
>
> 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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Adam - 19 Mar 2008 17:57 GMT

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
[quoted text clipped - 13 lines]
> The bracketed text above must be identical to the bracketed text in
> the query parameter.

Reply to this Message