show criteria on a report used to generate the report

  • Thread starter Thread starter Debbie S.
  • Start date Start date
D

Debbie S.

How do you show (print) on a report the criteria used to generate the report?

Thank you.

Debbie
 
How do you show (print) on a report the criteria used to generate the report?

Thank you.

Debbie

And what is the criteria on the report?

Let's assume the report criteria is in the query date field like:

Between [StartDate] and [EndDate]

In an unbound control in your report header, write:
= "For sales between " & [StartDate] & " and " & [EndDate]

The text within the brackets must be identical to the bracketed text
in the query.
 
Back
Top