Access 2007 Date For Query

In the query that runs the report (or the query you are going to create to run the report) in the "DATE" field, enter the following in the criteria:

Between [Start Date] and [End Date]

The query will prompt you for the starting and ending dates. Enter them.