How do I get a date range to show up in the header 1

[LeonBar]

I have a report created from a date range query. I start the report it asks me for the starting and ending dates, the report opens. In the header for that report I would like the name of the report and the date range I selected. Does anyone have a suggestion on how to accomplish this? Thank you.

Leon

 

[PaulBricker]

In a textbox, put your exact parameter that is in the query. If you query asks
Between [Enter Start Date] and [Enter End Date]
then the textbox in your report will be

="This report date range is between " & [Enter Start Date] & " and " & [Enter End Date]

Paul

 

[LeonBar]

Thank you Paul
that worked great exactly what we needed.

I love this forum!

Leon

 

[dhookom]

A star to Paul for a good answer and to mark the thread as resolved.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.