Answer: To display a parameter value in a report, you will need to redesign your parameter query to return the parameter as a field in the result set.
We've created an Access sample that you can download.
Download Access 2000 version
Let's take a look at this example.
We've created a query called qryCategories. This query will return all fields from the Categories table as well as a parameter called ParmValue (This parameter will be used to filter the data in the CategoryName field).
![](https://lh3.googleusercontent.com/-_B-D8xDUwcs/UBvQVUj7nJI/AAAAAAAAHhs/ZAB_78MZtuQ/s396/parm_rpt001.png)
When you run the query directly or through the report, the following message will appear. You will need to enter the parameter value.
![](https://lh4.googleusercontent.com/-NIZbkSK1XeY/UBvQVxc9d2I/AAAAAAAAHh0/Zlnf2m5Sb1w/s251/parm_rpt003.png)
Then you can place the parameter anywhere on the report. In this example, we've placed the parameter value at the top of the page.
![](https://lh5.googleusercontent.com/-1YRbcBaBY1g/UBvQWf5354I/AAAAAAAAHh4/7Pb6PhGiWg4/s489/parm_rpt002.png)
No comments:
Post a Comment