show parameters on report

jschneider998

Registered User.
Local time
Today, 11:27
Joined
Dec 4, 2002
Messages
22
I have a report that is running off a parameter query. The query prompts for the Beginning Date and then for the Ending Date for the report. How can I have those dates typed in show up on the report?
 
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]

HTH

Graham
 

Users who are viewing this thread

Back
Top Bottom