totn Access

MS Access 2003: Display parameter values in a report based on a parameter query

This MSAccess tutorial explains how to display parameter values in a report based on a parameter query in Access 2003 (with screenshots and step-by-step instructions).

Question: In Microsoft Access 2003/XP/2000/97, how do I display parameter values in a report based on a parameter query?

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 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).

Microsoft Access

When you run the query directly or through the report, the following message will appear. You will need to enter the parameter value.

Microsoft Access

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.

Microsoft Access