Report Header to Include Search Date???

  • Thread starter Thread starter Amy B
  • Start date Start date
A

Amy B

Here is my situation:
I have a report that I am running off a query. When you run the report it
prompts you to enter a date range you'd like to run the report for (One box
pops up for start date and one pops up for end date). I would like to
include the requested date range of the report in the header. Is there any
way to do that??
 
Here is my situation:
I have a report that I am running off a query. When you run the report it
prompts you to enter a date range you'd like to run the report for (One box
pops up for start date and one pops up for end date). I would like to
include the requested date range of the report in the header. Is there any
way to do that??
Click to expand...

Sure!
Add an unbound control to the Report Header.
Set it's control source to:
="Sales between " & [Start Date] & " and " & [End date]

The text within the brackets must be identical to the bracketed text
in the query criteria.
 
Back
Top