Receive data between two specified dates

[AbeA]

Hey folks.

I need to build a report that will allow users to pull data between TWO dates. I do have a query that will allow users to pull data by inputting a SINGLE date, which I've described below:

I have a report that displays the User ID, Arrival Time, Departure Time, and Job ID, and the Date. The report pulls from a query that allows you to specify which date you would like view the reports for. Works fine. In the Design View of the query, I have "[Enter the Date of your Report (MM/DD/YYYY)]" as the criteria.

How would I go about formatting this to list data between two dates? e.g. 09/12/2007 - 09/18/2007?

Thanks.

 

[rainman89]

query criteria would be

BETWEEN [Start date] and [End date]

 

[AbeA]

That did it. Thank you.