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

Between Dates

Status
Not open for further replies.
Joined
Oct 18, 2004
Messages
13
How can I get my report to run by dates between? I want to choose the dates each time. I have two date fields and only want to run reports by one of these dates. I have been to Microsoft's site and looked at FAQ here in Tek-Tips.

Thank You so Much,
NewCMISGRad
 
new,
Create a query and select all of the fields you want. In the criteria section of the date field you want to use type;
Between [Enter Begin date] and [Enter End date]
When you run the query it will bring up a parameter box for the Begin and End.
jim
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top