Printing Criteria on Reports

  • Thread starter Thread starter Arthur
  • Start date Start date
A

Arthur

I have a query that has criteria set to prompt for a
beginning date and an ending date so the data is inbetween
the date range.

I created a report from the query. Is it possible to have
the criteria print somewhere on the report?

Thanks

Artie
 
Arthur,
Add an unbound control to the report header.
Set it's control source to something like:
="For sales between " & [Enter Starting Date] & " and " & [Enter Ending
Date]

The text within the brackets must be identical to the query bracketed text.
 
You must log in or register to reply here.

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

Using Form for Criteria for Report 3
Parameter error when printing 8
Print requested date range on report 3
Including query dates in report 1
How do I print query parameters on the report? 2
Parameters in a Report 2
Conditional Format based on Query criteria 2
Criteria prompts 4

Back
Top