Print dates

  • Thread starter Thread starter McKeough
  • Start date Start date
M

McKeough

I have a query that runs: Between [Enter Start Date] And [Enter End Date] to determine which dates are brought into a report. When I open the report to this query, it asks for a Start Date and an End Date. How can I make the chosen dates also print in this report? Big-time beginner, no programming skills, self taught Access 2000 and running Windows 2000. Any suggestions?
 
I have a query that runs: Between [Enter Start Date] And [Enter End Date]
to determine which dates are brought into a report. When I open the report
to this query, it asks for a Start Date and an End Date. How can I make
the chosen dates also print in this report? Big-time beginner, no
programming skills, self taught Access 2000 and running Windows 2000. Any
suggestions?

Add a TextBox to the Report with the following as its ControlSource...

="Report Date Range: " & [Enter Start Date] & " to " & [Enter End Date]

The key is that the text between the square brackets must match exactly
with what you used in the query. If it does Access will not prompt the
user again, but will just use what was entered when the parameter box was
filled in.
 
Back
Top