show criteria on a report used to generate the report

D

Debbie S.

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

Thank you.

Debbie
 
F

fredg

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.
 

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

Top