Report Header to Include Search 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??
 
F

fredg

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??

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top