Print dates

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?
 
R

Rick Brandt

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.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to limit Parameters 7
Using an activex calendar to enter parameter values 3
Chart subform on report 12
Crosstab Query and Date Parameters 10
Date() not functioning as expected 12
Criteria in a calculated query field 6
Run a query based on a start date and end date. The date are the . 4

Top