Capturing report parameter

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
 
M

Marshall Barton

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.


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top