From access online help:
Print the criteria for a report in the report header
1 Create the criteria parameters in the report's underlying query.
How?
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 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 the 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]
Microsoft Access displays the parameter values exactly as you typed them in the prompt.
5 To see the criteria, print or preview the report.




Reply With Quote