Report Title/Header

[Susan Jayne]

Hi, Could you help please. I have based a Report on a Query which contains a parameter prompting for a start and end date.

What I am trying to do is include the start and end date (which are prompted for when opening the Report) in the title/heading of the Report ie Training from [start date from parameter prompt] to [end date from parameter prompt]

Hope this makes sense. Thanks in advance for your help.

Susan

 

[Rich@ITTC]

Hi Susan Jayne

Just create unbound text boxes in your Report Header and in the Control Source put the parameter wording used in the underlying query - e.g.

=[Enter Start Date]

and for the end date ...

=[Enter End Date]

HTH

Rich Gorvin

 

[Susan Jayne]

Hi Rich

Thanks very much - worked a treat!

Susan

 

[capri]

How does that work if your parameter is a word?

I have a report based on a query, where the parameter for a memo field is

Like "*" & [Enter Search Paramater] & "*"

The user types in a word or phrase and the query, then report returns all those records that contain said word. I would like to incorpate that word (eg Security) into the header. I've tried with and without the = sign but can't seem to get the parameter word into the header. Is it possible? Thanks.