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

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

Hi Rich

Thanks very much - worked a treat!

Susan

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.