Display Input Parameter on Report

TLW

Registered User.
Local time
Today, 21:42
Joined
Aug 27, 2001
Messages
22
I have set up my query to specify for an input parameter when the report runs. The input parameter is as follows in the criteria for the query:
"Between [Enter Shipping Beginning Date:] And [Enter Shipping End Date:]"

How can I display what the user enters for the input parameter on the report?
Thanks for any help!!
 
Add two extra columns to the query. In the field box of one type something like:
"DateBegin: [Enter Shipping Beginning Date:]", and in the other "DateEnd: [Enter Shipping End Date:]" (don't include the quotes).

This will cause the query to return two extra columns (DateBegin and DateEnd) on each record which will contain the two input parameters. You can then include them on the report just like any other values the query returns.

Make sure that the value between the [] brackets is spelt exactly the same as it is when it's used elsewhere.

Hope this helps.

Simon.
 
Instead of putting it in the query you can also put a text box on the actual report in the control source:

=Format([Enter Shipping Begining Date:],"mm/dd/yy") & " through " & Format([Enter Shipping End Date:],"mm/dd/yy")

Sohaila
smile.gif
 

Users who are viewing this thread

Back
Top Bottom