Between Dates

[NewCMISGrad]

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

 

[67peshawar294]

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