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
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set report criteria in code? 1
Print criteria for pie chart 3
Filtering subreports on main report 0
Filter Report from a ComboList list 2
Access Access Report Works on One Machine but not Another 3
Using Form for Criteria for Report 3
Report based on criteria form 5
Criteria from form on report 2

Back
Top