how to select certain records in a report.

  • Thread starter Thread starter Thanks, Buddy
  • Start date Start date
T

Thanks, Buddy

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
(e-mail address removed)
 
Back
Top