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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MsgBox on reports

Status
Not open for further replies.

sha123

Programmer
Nov 13, 2002
58
ZA
What will the code be when I want to get reports for a specific date,and not all 800 records?????

PLEASE HELP!!!!!!!
 
There are a couple of ways to do this but the easiest way is to
1. Base you Report on a Query
2. Add something like this to the Criteria line for the DateField in your query.
Between [EnterStartDate] and [EnterEndDate]

This will prompt the user to select a start and finish date. Then the report will be filtered by whatever dates are entered in the query parameters.

Paul
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top