Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing a Report within a Date Range 1

Status
Not open for further replies.

Borian

Technical User
Jan 16, 2004
17
US
I'm hoping that someone can point me to a good walk through for printing reports with a user defined date range.

I've seen this on several of the example databases with Access, but I can't seem to figure out how the go about setting it up.

Thanks for any help,

Paul
 
Paul,

If the report is based on a query for the criteria on the date field you can do the following -

Between [Enter Start Date] and [Enter End Date]


If a form with the start and end dates determines what happens with the report then the logic would look something like this -

Between Forms![MyForm]![StartDate] and Forms![MyForm]![EndDate]


HTH,

Steve
 
Thanks that worked for what I needed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top