Query Criteria in Reports

[jacque427]

I have a report based upon a query using a certain criteria.

Is there a way for the report to show what criteria is requested via the query?

For example you run the report and it asks for a name.
You type in "Smith" and the report gives you all the records with "Smith". How can I show "Smith" (the criteria) in the report header?

 

[THWatson]

jacque427
Create a text box in your report header. In it put exactly the same expression as you use as criteria in the column in the query, preceded by the = sign.

For example, if your query parameter asks [Enter LastName], then in the text box in your report header put
=[Enter LastName]

Be sure to type it exactly the same as the criteria in your query or you will be asked for the same parameter twice.

If you want to include other text, do it this way...
="This report includes all records for the name " & [Enter LastName]

Tom

 

[jacque427]

*PERFECT*,thanks so very much.



jacque


Just knowlegeable enough to cause problems.