Date Parameters on a Report

[Haynesey]

Hi,

Is it possible when running a paramater query (Between two specified variable dates) for the two dates entered to be displayed on a report?

Thanks in advance
Lee

 

[Mile-O]

Rather than requesting the dates through parameters, allow the use to set the date range on the form that calls the report.

This way, the query that the report runs off can reference the form and get the values as criteria rather than prompting the user with the "Enter Parameter Value" box.

The report can then reference the form values too.

 

[Graham T]

How to Print Parameters onto your report:

If you've based a report on a parameter query, you can print the parameters as part of your report. For instance, if your parameter is a date, you can print that date in the header of your report. Simply add a text box to your report's header and specify the parameter by name as the control's Control Source using the form

=Reports![reportname]![parametername]

Let's suppose you want to add the feature to a report named rptHolidayRequests and your query's parameter is Between [Enter Start Date] And [Enter End Date]. In this case, you'd enter the expressions of

=Reports![rptHolidayRequests]![Enter Start Date]

=Reports![rptHolidayRequests]![Enter End Date]