You can use >=[Enter Start Date] and <=[Enter End Date]
I would consider using a Form for this.
Your Starter for 10:
Create a simple
Add 2 Textboxes, rename them txt_StartDate and txtEndDate
Save the form, say frm_TestDates
Open your Query.
Right-click on the criteria and choose Build...
Select Forms>All Forms>frm_TestDates
in the top box type >=
You should then be able to select the txt_StartDate from the bottom middle box.
Your syntax should look like this:
>=[Forms]![frm_TestDates]![txt_StartDate]
Do the same for EndDate.
<=[Forms]![frm_TestDates]![txt_EndDate]
Save the Query.
Goto the design view of your Form
Add a button,
In the new dialogue box select Miscellaneous>Run Query
Choose your query
Run through the rest of the wizard as you wish.
now you can load the form and enter a Start Date and End Date.
Hit the button, and Bingo.
Hope that gets you started
Regards,