Print the criteria for a report in the report header

1. In a Microsoft Access database (.mdb), create the criteria parameters in the report's underlying query. In a Microsoft Access project (.adp), create the parameters in the report's underlying stored procedure.
   
   
2. Open the report in Design view.
   
   
3. Create an unbound text box for each parameter you want to display. Click the Text Box tool in the toolbox, and then click in the report header.
   
   
4. To display the property sheet, make sure the text box is selected, and then click Properties on the toolbar.
   
   
5. Do one of the following:
   • In an Access database, set the ControlSource property to the parameter(s) you specified in the Criteria cell in the query. For example, if the parameters in the query are:

     Between [Type a beginning date] And [Type an ending date]

     and you want to display them in two text boxes, set the ControlSource property of one text box to:

     [Type a beginning date]

     and the ControlSource property of the other text box to:

     [Type an ending date]

     If you want to display both parameters in one text box, you can use an expression in the ControlSource property box; for example:

     ="Between " & [Type a beginning date] & " and " & [Type an ending date]

   • In an Access project, set the report's InputParameters property to a string that specifies the parameters that are passed to the stored procedure that the report is bound to. As in the following example, the string must be an expression that includes the parameters you specified in the stored procedure and the text you want to appear in the prompt; enclose the prompt text in square brackets ([ ]):

     @Beginning_date datetime = [Beginning Date], @Ending_date datetime = [Ending Date]

     Then set the ControlSource property of the control to a string that specifies the parameters in the stored procedure, any text you want to include, and the prompt text enclosed in square brackets as shown in the following example:

     ="Sales from "& [Beginning Date] &" to "& [Ending Date]

6. To see the criteria, print or preview the report. Microsoft Access displays the parameter values exactly as you typed them in the prompt.

Note   The Employee Sales by Country report in the Northwind sample database prints the criteria in the report header. To view this report, open the Northwind database in the Samples subfolder of your Office folder, and then open the Alphabetical List of Products report in Design view. For information on opening Northwind, click .