how to select certain records in a report.

Hi, I want to run a report - but I only want to select certain dates (I have
a date field). Like, maybe, I want to run a report based on sales from Dec 8
- 12, 2009, for example. I'm not quite sure how to go about it.

thanks!

You are probably opening your report with a commqnd button on a form so add
two unbound textboxes on the form named StartDate and EndDate, Then make the
recordsource of the form a query that contains the date field. Set the
criteria of the date field to:
Between Forms!NameOfYourForm!StartDate And Forms!NameOfYourForm!EndDate

Note - your form must be open when you open the report.

Steve




"Thanks, Buddy" wrote in message
...
Hi, I want to run a report - but I only want to select certain dates (I
have
a date field). Like, maybe, I want to run a report based on sales from
Dec 8
- 12, 2009, for example. I'm not quite sure how to go about it.

thanks!