Date on Report

[Guest]

Is there a way to put the date range on the report from the input dialog box?
When you enter the start date and end date, I would like to see a report
header for the date range entered. Thanks!!!

 

[Wayne Morgan]

Is the input box prompt coming from a parameter in the query feeding the
report? If so, I believe you'll find this helpful.

http://support.microsoft.com/kb/208630/en-us

 

[Guest]

I have a new report and in the query I am using Between #1/1/2005# And
#3/31/2006# How can I still put the date ranges for the report at the header?

Thanks

 

[Wayne Morgan]

Are you saying that you've "hard coded" the dates into the query? If so,
then this isn't very changeable, so just hard code them into the report also
(i.e. place a label or textbox in the header and type in what you want it to
say). The method I gave before will let you change the desired dates each
time the query is run and will allow the report to pick up on those changes.