Putting Selected Start and End Dates in Report Title

[Icky_Joe]

I need an Access guru to guide me to the light.

I created a report from a Query that asks for a start date and an end date. The start and end dates are captured using an expression in the criteria in field Date Effective - Between [Enter Beginning Date (ie 01/01/11)] And [Enter Ending Date (ie 01/01/12)]. I would like to include the start and end dates selected in the Report Header so the requested will know what dates were used for the report. How do I do this?

[pbaldy]

At it's simplest a textbox control source of:

=[Enter Beginning Date (ie 01/01/11)]

or you can build a string

="From " & [Enter Beginning Date (ie 01/01/11)] & " to " & [Enter Ending Date (ie 01/01/12)]

The key is the text must exactly match the parameters or you'll get prompted twice.

[Icky_Joe]

pbaldy - u sir are the MAN! worked like a charm. thanks so much for taking the time to help me.

[pbaldy]

Happy to help!