Query/Report

  • Thread starter Thread starter Steven Phillips via AccessMonster.com
  • Start date Start date
S

Steven Phillips via AccessMonster.com

I run a query to retrieve data between dates and print a report based on
the results. How can I show/print on the report the date range of the data.
Steve
 
Hi,

I presume you are using a parameter query.
Let's say they are:
[Please enter a start date]
and
[Please enter an end date]

In the report, add a text box and in the Control Source property enter
something like:
= "Report is run for the dates: " & [Please enter a start date] & " to "
& [Please enter an end date]
 
Back
Top