Capturing report parameter

  • Thread starter Thread starter Shannon
  • Start date Start date
S

Shannon

I have designed a report based on a query. A parameter to
the report is not a field on the query. I would like to
capture that parameter and display it on the Report HEADER
or Page Header. Have not been able to figure out how to
capture the parameter value.
Any help is much appreciated.
Thanks,
Shannon
 
Shannon said:
I have designed a report based on a query. A parameter to
the report is not a field on the query. I would like to
capture that parameter and display it on the Report HEADER
or Page Header. Have not been able to figure out how to
capture the parameter value.
Click to expand...


You can use the parameter in your report pretty much as if
it really were a field in the query. Just make sure you
spell it **exactly** as you did in the query. Example text
box control sources:

=[Select Company Name]

="Orders from " & [Start Date] & " to " & [End Date]

=Forms!someform.sometextbox
 
Back
Top